Help with an IF AND statement, possible a rollup?

Question

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 Answer

Hi @czacza2007,You can use this article to create your formula              Airtable - Support        Using checkbox fields in formulasWhen 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 · Answer

Hi @czacza2007,You can use this article to create your formula              Airtable - Support        Using checkbox fields in formulasWhen 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,MoThanks Mo, that fixed it!

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded