Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formulas for financing

Topic Labels: Base design
318 1
Showing results for 
Search instead for 
Did you mean: 

I am trying to create a formula for renovation of flipping houses. My scenario is this:

I have a purchase price. I also have 8% commissions coming out of total sale. I want to be able to input value x (possible total sale price) - 8% then - again the purchase price which would give me a field with a possible renovation budget.

So it would look something like {(enter any number value x) - 8%)} - purchase price = new value

1 Reply 1

Will this work? Guessing the field names…

{Total Sale Price} - ({Total Sale Price} * .08) - {Purchase Price}