Help

Formula including %

Topic Labels: Formulas
Solved
Jump to Solution
1117 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Michelle_Walls
4 - Data Explorer
4 - Data Explorer

HI 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%.

((({Product}-({Product}*.05))-(25%))-{COGS})
 
Any help is appreciated!  Thanks
1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

3 Replies 3

Hi,
i have another result
100*0.95*0.75^2=53.4375

kuovonne
18 - Pluto
18 - Pluto

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