Help with an IF AND statement, possible a rollup?

[czacza2007]

Hello, I’m trying to do a formula that calculates commision due. I have the commission field, and I also have a ‘commision paid’ checkbox field.

Basically I want the commission owing field to calculate the commission if the paid field isn’t ticked yes.

Help please!

[Mohamed_Swella1 · Accepted solution]

Hi @czacza2007,

You can use this article to create your formula

Airtable - Support

Using checkbox fields in formulas

When working with checkbox fields and formulas, "= 0" means that a box has not been checked, and "= 1" means that a box has been checked. So, to make a formula field which retur...

Basically, it will be something like IF({Commission Paid} = 0, Commission, 0)

BR,
Mo

[czacza2007]

Thanks Mo, that fixed it!