Equivalent for Min and Max Formulas in Excel
complete
H
Hakan
For some calculations, like graduated pricing, I often need a formula similar to the min and max formulas in Excel. For example, something like this: MIN(MAX($B$2−25;0);75). I’ve tried using IF operators, but it seems to fail in one way or another. I think this would be helpful for many people, so I’d really appreciate it if you could consider adding this feature.
Zac @ Soulver
complete
We have phrases for this in Soulver (smaller of x and y, and larger of x and y).