Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

# Need Help figuring out the 3rd Number

Topic Labels: Formulas
Solved
399 3
cancel
Showing results for
Did you mean:
7 - App Architect

I have only 2 numbers

1. 15%
2. 161.80

I have to get after the deal is done \$161.80 and the the other guy have to get 15% of the deal.

So the total deal will be \$190.35 - (161.8 is a 15% decrease of 190.35.)

How can I get to this number (\$190.35) in Airtable, when I have only the 2 other numbers (1. 15% 2. 161.80)

In Excel I will make this as follows =161.8 / (1-15%) but I can not make this work in Airtable

1 Solution

Accepted Solutions
Airtable Employee

You’ll just need to change `15%` to `.15`, making the formula `{Total Cost} / (1-.15)`. Then, make sure to format your field as currency. Hope that helps!

3 Replies 3
Airtable Employee

You’ll just need to change `15%` to `.15`, making the formula `{Total Cost} / (1-.15)`. Then, make sure to format your field as currency. Hope that helps!

7 - App Architect

Thank you very much , Quick Help

Airtable Employee

Happy to help Abraham!