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
Sep 09, 2020 11:34 PM
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
Sep 10, 2020 09:33 PM
Will this work? Guessing the field names…
{Total Sale Price} - ({Total Sale Price} * .08) - {Purchase Price}