Forum Discussion
Help with a simple calculator for figuring a calculated cost
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.
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.