# Formula including %

Topic Labels: Formulas
Solved
669 3
cancel
Showing results for
Did you mean:
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
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}

3 Replies 3
12 - Earth

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

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}

4 - Data Explorer

YESSSSS - THANK YOU!  This is spot on. Genius - thanks!