Largest number

  • Thread starter Thread starter MAX
  • Start date Start date
M

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.
 
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
 
Back
Top