Help

Help with an IF AND statement, possible a rollup?

Topic Labels: Formulas
Solved
Jump to Solution
793 2
cancel
Showing results for 
Search instead for 
Did you mean: 
czacza2007
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @czacza2007,

You can use this article to create your formula

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

BR,
Mo

See Solution in Thread

2 Replies 2
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @czacza2007,

You can use this article to create your formula

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

BR,
Mo

Thanks Mo, that fixed it!