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

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

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

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

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