Dec 30, 2022 05:53 AM
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
Solved! Go to Solution.
Dec 30, 2022 08:48 AM
Hello!
I believe you could use the following IF formula:
Dec 30, 2022 08:48 AM
Hello!
I believe you could use the following IF formula:
Jan 02, 2023 09:13 AM
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.
Jan 03, 2023 06:46 AM
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!