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
|