Try the MAX function...

=MAX(C1:C4)

--
Rick (MVP - Excel)


"MAX" wrote in message
...
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.