View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ferde ferde is offline
external usenet poster
 
Posts: 87
Default 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