Excel - Compare two cells and display the larger number?

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.

3 Answers

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."

If you want to use the function IF you have to write the formula as follows and obtain the same result: =if(A1>B1;A1;B1)

=IF(A>C,B,D)

If A is Greater than C return B else return D

A=50
B=1650
C=55
D=1870

Copy formula in cell you want the return value in.