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

S

stefan.crowe

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare last digit in 5 cells for match 0
Fill cells based on the other 3 cells unique combination the value on the target cell 0
how to calculate the difference of values (numbers) in a column? 1
Help Creating Excel Formula 4
Varying cell ranges in formulas according to number of cells with certain value 1
How to delete ALL cells containing the same data --- REVISED 0
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Creating a formula relating to several cells 2

Top