Excel Forum

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.