
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 28, 2023 10:56 AM
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%.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 28, 2023 06:01 PM
@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}
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 28, 2023 05:42 PM
Hi,
i have another result
100*0.95*0.75^2=53.4375

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 28, 2023 06:01 PM
@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}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 31, 2023 06:20 AM
YESSSSS - THANK YOU! This is spot on. Genius - thanks!
