Forum Discussion
Solved
Help with a simple calculator for figuring a calculated cost
Hello, I am making a simple calculator for work. I enter square footage in cell E16 and have an equation to give a dollar value in cell K16. Trying to make things simple for others to price a job...
I recommend this formula, as used in the attached example.
=MAX(MinChg,SqFt*SFRate)You'll notice no numbers in the formula. Instead, there are cells off to the side that define your Minimum, and your current Rate per Sq Ft. Doing it this way gives you the flexibility to change either or both of those numbers without revising the formula. Doing it this way is avoiding what's called "hard coding" of values.
You can use the MAX function to set a minimum value of 300. Try this formula in K16: