| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate out of 3 cells choose highest number
I need a formula that essentially will look at 3 cells and then produce the
larger number of the 3 cells |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to calculate out of 3 cells choose highest number
=MAX(A1:A5)
or for non-contiguous cells. =MAX(A1,C1,K1) HTH, Paul -- "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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to calculate out of 3 cells choose highest number
On Tue, 5 Feb 2008 10:58:01 -0800, esparzaone
wrote: I need a formula that essentially will look at 3 cells and then produce the larger number of the 3 cells =MAX(cell_ref) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i choose the highest number in excel range | Excel Worksheet Functions | |||
| Choose highest value duplicate | Excel Worksheet Functions | |||
| what function do I use for excel to choose the 2nd highest number | Excel Worksheet Functions | |||
| Excel Formula - to calculate highest number from a set of numbers | Excel Worksheet Functions | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
