Largest number 2

[MAX]

I have a range of cells with a number in each cell (below).
Cell C1 2
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell C1.

Thanks

 

[Jacob Skaria]

=MAX(C1:C4)


If this post helps click Yes

 

[Gary''s Student]

In C1 enter:
=MAX(C2:C4)

 

[John]

Hi Max
Type this =MAX(C2:C100) in C1, change range to your needs
HTH
John