| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to add the highest value
A B C D E
21 10 5 2 23 15 20 7 5 25 Is there a formula that would take the highest value in columns A,B,or C and add it to column D to give me the result I'm looking for in E1. In my example above the highest value is in cell A1 and so that is added to D1 to give the result of 23 in cell E1. In my second example the highest value is in Cell B2 and so that is added to D2 to give the result of 25 . Thank you in advance for the help, Deb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| Using the highest 2 out of 3 values in a formula | Excel Discussion (Misc queries) | |||
| How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
| Formula to sum and list highest to lowest | Excel Worksheet Functions | |||
Threaded Mode
