Help in checking 5 cells for value and display the value in anothercell
 

I have a worksheet that I need to look a 5 cells A1,A2,A3,A4,A5. I
need a fuction that looks at what in eachof the cells and and
whichever cell has the highest value display that value in cell d1.

Can someone HELP!!

example:
A1 400
A2 500
A3 450
A4 550
A5 350

D1 should show 550 from A4 because of all the values in the cells A4
is the highest number. If A1 had the highest number D1 would show waht
is in A!.

Thanks in advance!

Help in checking 5 cells for value and display the value in anothe
 

in cell D1, enter the formula:
=MAX(A1:A5)

" wrote:

I have a worksheet that I need to look a 5 cells A1,A2,A3,A4,A5. I
need a fuction that looks at what in eachof the cells and and
whichever cell has the highest value display that value in cell d1.

Can someone HELP!!

example:
A1 400
A2 500
A3 450
A4 550
A5 350

D1 should show 550 from A4 because of all the values in the cells A4
is the highest number. If A1 had the highest number D1 would show waht
is in A!.

Thanks in advance!

Help in checking 5 cells for value and display the value in another cell
 

in D1 enter the following

=MAX(A1:A5)

Hope that helps.


wrote in message
...
I have a worksheet that I need to look a 5 cells A1,A2,A3,A4,A5. I
need a fuction that looks at what in eachof the cells and and
whichever cell has the highest value display that value in cell d1.

Can someone HELP!!

example:
A1 400
A2 500
A3 450
A4 550
A5 350

D1 should show 550 from A4 because of all the values in the cells A4
is the highest number. If A1 had the highest number D1 would show waht
is in A!.

Thanks in advance!

Help in checking 5 cells for value and display the value in another cell
 

=MAX(A1:A5) entered in D1


Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 15:59:55 -0700 (PDT), wrote:

I have a worksheet that I need to look a 5 cells A1,A2,A3,A4,A5. I
need a fuction that looks at what in eachof the cells and and
whichever cell has the highest value display that value in cell d1.

Can someone HELP!!

example:
A1 400
A2 500
A3 450
A4 550
A5 350

D1 should show 550 from A4 because of all the values in the cells A4
is the highest number. If A1 had the highest number D1 would show waht
is in A!.

Thanks in advance!