How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

Hi,

What do you mean? the result of all tese IF's shoud come to one cell? but it
dosn't make sense, what if all these IF's return TRUE or 2 of then would be
TRUE and one of them FALSE? please explain.

Thanks,

--
Farhad Hodjat


"tssgraham" wrote:

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

I'll try to explain. The cells I'm dealing with all contain currency amounts.
I have three columns of totals that I need to be able to examine line by line
to determine which of the three is the greatest amount and then have the
greatest of the three total up in one of three other fields. Sorry to be so
confusing. Todd.

"Farhad" wrote:

Hi,

What do you mean? the result of all tese IF's shoud come to one cell? but it
dosn't make sense, what if all these IF's return TRUE or 2 of then would be
TRUE and one of them FALSE? please explain.

Thanks,

--
Farhad Hodjat


"tssgraham" wrote:

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

Here is my original post if that helps at all:

I need to look at the data in three fields, determine which is the highest of
the three and then have the highest of the three fields add up in a fourth
field. I'll try to type in an example; if a1 is greater than a2 and greater
than a3 then a1 needs to be posted into a4, but if a2 is greatest than a2
needs to be posted in a5 and if a3 is greatest it needs to be posted in a6.
Hope I didn't confuse you too much! Thanks. Todd.


"Farhad" wrote:

Hi,

What do you mean? the result of all tese IF's shoud come to one cell? but it
dosn't make sense, what if all these IF's return TRUE or 2 of then would be
TRUE and one of them FALSE? please explain.

Thanks,

--
Farhad Hodjat


"tssgraham" wrote:

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

Perhaps this formula?

A4:
=IF(A1=MAX($A$1:$A$3),A1)+IF(B1=MAX($B$1:$B$3),B1) +IF(C1=MAX($C$1:$C$3),C1)

Copy that formula down through A6

Does that help?

(also...Next time, please stay in the same thread when only clarifying the
request)

***********
Regards,
Ron

XL2002, WinXP


"tssgraham" wrote:

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

Hi,

in the cell A4: =IF(A1=MAX($A$1:$A$3),A1,"")
in the cell A5: =IF(A2=MAX($A$1:$A$3),A2,"")
in the cell A6: =IF(A3=MAX($A$1:$A$3),A3,"")

Thanks,

--
Farhad Hodjat


"tssgraham" wrote:

Here is my original post if that helps at all:

I need to look at the data in three fields, determine which is the highest of
the three and then have the highest of the three fields add up in a fourth
field. I'll try to type in an example; if a1 is greater than a2 and greater
than a3 then a1 needs to be posted into a4, but if a2 is greatest than a2
needs to be posted in a5 and if a3 is greatest it needs to be posted in a6.
Hope I didn't confuse you too much! Thanks. Todd.


"Farhad" wrote:

Hi,

What do you mean? the result of all tese IF's shoud come to one cell? but it
dosn't make sense, what if all these IF's return TRUE or 2 of then would be
TRUE and one of them FALSE? please explain.

Thanks,

--
Farhad Hodjat


"tssgraham" wrote:

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

Thanks Ron. I tried that and received the "VALUE" error. I'm heading home
now, this problem can wait until Monday! Have a great weekend. Todd.

"Ron Coderre" wrote:

Perhaps this formula?

A4:
=IF(A1=MAX($A$1:$A$3),A1)+IF(B1=MAX($B$1:$B$3),B1) +IF(C1=MAX($C$1:$C$3),C1)

Copy that formula down through A6

Does that help?

(also...Next time, please stay in the same thread when only clarifying the
request)

***********
Regards,
Ron

XL2002, WinXP


"tssgraham" wrote:

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)

Hi Todd,

Type them in without the absolute references as..

in the cell A4: =IF(A1=MAX(A1:A3),A1,"")
in the cell A5: =IF(A2=MAX(A1:A3),A2,"")
in the cell A6: =IF(A3=MAX(A1:A3),A3,"")


Highlight A4 to A6 and drag across as far as you need.

HTH
Martin