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

put this in E1

=MAX(A1:C1)+D1


On Jul 19, 12:48*am, ferde wrote:
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

=max(a1:c1)+d1

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ferde" wrote in message
...
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

Try this:

=MAX(A1:C1)+D1

Copy down as needed.

--
Biff
Microsoft Excel MVP


"ferde" wrote in message
...
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

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),D1:D6)+MAX(A1:A6)

and this in e2
=MAX(IF(B1:B6=MAX(B1:B6),D1:D6))+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" wrote:

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

Thank you very much everyone

"Mike H" wrote:

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),D1:D6)+MAX(A1:A6)

and this in e2
=MAX(IF(B1:B6=MAX(B1:B6),D1:D6))+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" wrote:

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