Largest number

[MAX]

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

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

Thanks.

 

[Rick Rothstein]

Try the MAX function...

=MAX(C1:C4)

 

[Niek Otten]

In B1:

=MAX(C1:C4)

 

[vezerid]

Use your name <s>.

=MAX(C1:C4)

HTH
Kostis Vezerides

 

[Eduardo]

Hi,
=LARGE(c1:c4,1)

1 will give you the largest
2 will give you the 2nd largest and so on

If this helped please click yes, thanks