Help

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

Solved
Jump to Solution
1137 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Leidens
5 - Automation Enthusiast
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 

 

 

Capture d’écran 2022-12-30 à 14.46.05.png

 

Capture d’écran 2022-12-30 à 14.52.36.png

1 Solution

Accepted Solutions
Daniel_Orseno
5 - Automation Enthusiast
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.

See Solution in Thread

3 Replies 3
Daniel_Orseno
5 - Automation Enthusiast
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.
Michael_Leidens
5 - Automation Enthusiast
5 - Automation Enthusiast

@Daniel_Orseno 

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. 

 

Capture d’écran 2023-01-02 à 18.12.27.png

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!