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 have looked over all the help topics and many forum threads but nothing seems to help.
Let me recommend this website for your future researching and learning. Part of the "secret" of finding things like this is to think about normal human words that might describe the task. For example, in this case, you might think MINIMUM or MAXIMUM. Using either one as a search term in the website would get you to the formula/function you need. And in the course of it, you'd learn other tricks as well.