Thread: formula to calculate out of 3 cells choose highest number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default formula to calculate out of 3 cells choose highest number
=MAX(A1,A2,A3)
or
=MAX(A1:A3)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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


Reply With QuoteReply With Quote