Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help with an IF AND statement, possible a rollup?

Topic Labels: Formulas
Solved
Jump to Solution
438 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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!