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