View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default formula to calculate out of 3 cells choose highest number

Try this:

=MAX(A1:A3)

Or:

=MAX(A1,F1,K1)

--
Biff
Microsoft Excel MVP


"esparzaone" wrote in message
...
I need a formula that essentially will look at 3 cells and then produce the
larger number of the 3 cells