Excel – Compare two cells and display the larger number

comparisonconditional statementsmicrosoft excel

Can someone tell me how to compare two cells (numbers), and then display the larger cell?

Cell C1 = IF A1 > B1 then display A1 else display B1

Sorry I'm not an excel pro.

Best Answer

A bit late but if someone else is having trouble: The MAX(number1;number2;...) function is what you're looking for. "Returns the largest value in a set of values. Ignores logical values and text."

Related Question