formula to add the highest value

[ferde]

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

 

[muddan madhu]

put this in E1

=MAX(A1:C1)+D1

 

[Don Guillett]

=max(a1:c1)+d1

 

[T. Valko]

Try this:

=MAX(A1:C1)+D1

Copy down as needed.

 

[Mike H]

Hi,

What you have asked for is this
In E1
=MAX(A:A)+D1

and in e2
=MAX(B:B)+D2

But do you really mean this in e1

=IF(A1:A6=MAX(A1:A6),D16)+MAX(A1:A6)

and this in e2
=MAX(IF(B1:B6=MAX(B1:B6),D16))+MAX(B1:B6)

Note these last 2 are array formula. see instructions below.

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array.

Mike

 

[ferde]

Thank you very much everyone

Hi,

What you have asked for is this
In E1
=MAX(A:A)+D1

and in e2
=MAX(B:B)+D2

But do you really mean this in e1

=IF(A1:A6=MAX(A1:A6),D16)+MAX(A1:A6)

and this in e2
=MAX(IF(B1:B6=MAX(B1:B6),D16))+MAX(B1:B6)

Note these last 2 are array formula. see instructions below.

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array.

Mike