formula to calculate out of 3 cells choose highest number

[esparzaone]

I need a formula that essentially will look at 3 cells and then produce the
larger number of the 3 cells

 

[T. Valko]

Try this:

=MAX(A1:A3)

Or:

=MAX(A1,F1,K1)

 

[Niek Otten]

=MAX(A1,A2,A3)
or
=MAX(A1:A3)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need a formula that essentially will look at 3 cells and then produce the
| larger number of the 3 cells

 

[PCLIVE]

=MAX(A1:A5)

or for non-contiguous cells.
=MAX(A1,C1,K1)

HTH,
Paul

 

[Ron Rosenfeld]

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