MAX function
TheMAX functionreturns the largest numeric value in the data provided.
The MAX function can be used to return the largest value fromanytype of numeric data.
Otherwise return C5".
This is a perfectly valid Excel formula, and you will often encounter IF formulas that follow this structure.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
More than one condition can be tested by nesting IF functions.
