Excel Forum
Similar Content
MAX and MIN Values from a Filtered List in Excel
Tutorial: How to get the MAX and MIN values from a filtered data set. This method returns the value ...
Make All Text Upper Case or Lower Case in Excel
Tutorial: How to quickly change all text to upper case or lower case in Excel.  This allows you to c...
Capitalize First Letter of Every Word in a Cell - PROPER Function
Tutorial: In Excel you can use a function to capitalize the first letter of every word in a cell.  T...



Excel Magic Trick 99 Instead of IF function use MAX and MIN!


See how to use the IF and the MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle in three different ways!

Amazing use for the MAX and MIN functions instead of the IF function!

Formula and functions





Got a Question? Ask it Here in the Forum.