+2HI All! I'm trying to create a formula but am stuck.
A $100 product minus 5%.
That total minus 25%.
That full total minus $25.
For an end total of $46.25
Here's what I have as a formula, but it's just not working out! I can't tell if it's the parenthesis or the actual 25%.
Best answer by kuovonne
@Alexey_Gusev The final step is to subtract $25, not 25%.
@Michelle_Walls You have an issue with trying to translate from English to Airtable formula language with the same word order. You ended up with issues with order of operations and some other problems.
Try this …
({Product} * 0.95 * 0.75) - {COGS}
+25Hi,
i have another result
100*0.95*0.75^2=53.4375
+29@Alexey_Gusev The final step is to subtract $25, not 25%.
@Michelle_Walls You have an issue with trying to translate from English to Airtable formula language with the same word order. You ended up with issues with order of operations and some other problems.
Try this …
({Product} * 0.95 * 0.75) - {COGS}
+2@Alexey_Gusev The final step is to subtract $25, not 25%.
@Michelle_Walls You have an issue with trying to translate from English to Airtable formula language with the same word order. You ended up with issues with order of operations and some other problems.
Try this …
({Product} * 0.95 * 0.75) - {COGS}
YESSSSS - THANK YOU! This is spot on. Genius - thanks!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.