Help with an IF AND statement, possible a rollup?

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!

Hi @czacza2007,

You can use this article to create your formula

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


Thanks Mo, that fixed it!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.