View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Largest number 2

In C1 enter:
=MAX(C2:C4)
--
Gary''s Student - gsnu200850


"MAX" wrote:

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