Essentially, we want to force negative numbers to zero.
If B5 is less than zero, IF returns zero.
Otherwise, IF returns the original number.
Both formulas work fine.
The MAX formula above is just an elegant way to replace the slightly more complex IF formula.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
