| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking cells are = and return a value | Excel Discussion (Misc queries) | |||
| Checking cells for 2 conditions | Excel Worksheet Functions | |||
| Checking the Cells in Sheet1 with Cells in Sheet2 and replace | Excel Worksheet Functions | |||
| Checking Blank Cells | Excel Worksheet Functions | |||
| Checking that any cells are null | Excel Worksheet Functions | |||
Linear Mode
