Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

# If function (If column A = True, then .., otherwise Column B

Solved
128 3
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi,

How should I write the IF function to calculate commission based on A or B ?

See below:

If Take Rate is filled: Commission = GMV x Take Rate %

Otherwise: Commission = GMV - Achat Distributeur

Thank you

1 Solution

Accepted Solutions
5 - Automation Enthusiast

Hello!

I believe you could use the following IF formula:

IF({Take Rate %}, {GMV} {Take Rate %}, {GMV} {Achat Distribteur})

Note that for the GMV part of the above formula you will have to put the full field name, not just GMV.
3 Replies 3
5 - Automation Enthusiast

Hello!

I believe you could use the following IF formula:

IF({Take Rate %}, {GMV} {Take Rate %}, {GMV} {Achat Distribteur})

Note that for the GMV part of the above formula you will have to put the full field name, not just GMV.
5 - Automation Enthusiast

Thank you! It's so simple when you get the way to write the formula. Maybe you can help me going to the next level?

How to integrate IF condition, but 2 times in the same Formula?

In column "A verser €“, I need to say :

If({com'distri HT},....... (all the formula below) ; OR ;  IF({Take Rate %}, {GMV} * {Take Rate %}, {GMV} - {Achat Distribteur})

So.. to understand the context: we need to calculate how much we pay to our suppliers. we have 2 kind of contracts (Take rate or Gross margin on products).  "A verser" (to wire in English) take in count part of VAT, transportation, transport, etc..

Take Rate is easy, it's a %age on GMV ;

But Gross Margin is completely different.   I succeeded the IF formula (thanks again). But for this one, it's more complicated. Thank you for your time.

5 - Automation Enthusiast

Sure thing, I'm happy to help!

Looks like for this second one you are looking for a nested If statement (How to Write Nested IF Statements | Airtable Support). I think you might just be able to take the formula you showed in the screenshot, remove the "Or" and add the second IF statement to the end of the first one. Hopefully that makes sense and helps!