Skip to main content
Solved

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

  • December 30, 2022
  • 3 replies
  • 46 views
M
Forum|alt.badge.img+5

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 

 

 

 

Best answer by Daniel_Orseno

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

    D
    Forum|alt.badge.img+4
    • Daniel_Orseno
    • New Participant
    • Answer
    • December 30, 2022

    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.
    M
    M
    Forum|alt.badge.img+5
    • Michael_Leidens
    • Author
    • Participating Frequently
    • January 2, 2023

    @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. 

     

    D
    Forum|alt.badge.img+4
    • Daniel_Orseno
    • New Participant
    • January 3, 2023

    @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. 

     


    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! 

    Terms & ConditionsAccessibility statement