Tired of the IF function? Replace ugly IFs with MAX or MIN
Sometimes, you want to check the result of a calculation first before you return a final result. Maybe you want to trap negative values, and display zero instead? You can certainly use the IF function to do this, but you might be able to build a more elegant formula with MIN or MAX instead.
Add a comment...