View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Return a High Number

If your numbers are in A1:C10 then =MAX(A1:C10) returns the highest number
in the range.

Tyro

"Anthony" wrote in message
...
Is there a formula if in diffrent cells I have a number and I want it to
return the highest number is that area. If anyone could please help.

Thanks