Formula including %

[Michelle_Walls]

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

[Alexey_Gusev]

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

[kuovonne · Accepted solution]

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

[Michelle_Walls]

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