Compare data in three fields
 

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.

Compare data in three fields
 

With
A1:A3 containing numbers

Try something like this:
A4: =IF(A1=MAX($A$1:$A$3),A1,"")
Copy that formula down through A6

Note: with that formula, if there are ties for largest value, the value will
display in each appropriate cell within A4:A6

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"tssgraham" wrote:

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.

Compare data in three fields
 

In A4, =IF(A1=MAX(A$1:A$3),A1,"") and copy down to A5 and A6. I'm assuming
that you want the cell blank if the condition isn't satisfied. You haven't
said what you want if there is a tie for top spot.
--
David Biddulph

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

Compare data in three fields
 

AWESOME! Thank you! Now . . . how do I use this to be able to add multiple
"IF" formula's? I'll try to explain. I have data in three columns that need
to be compared just as your formula allows, but then I also need to compare
data in multiple sets of three colums and have the max in each add to the
first formula? Have I confused you yet? Thanks again. Todd.


"Ron Coderre" wrote:

With
A1:A3 containing numbers

Try something like this:
A4: =IF(A1=MAX($A$1:$A$3),A1,"")
Copy that formula down through A6

Note: with that formula, if there are ties for largest value, the value will
display in each appropriate cell within A4:A6

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"tssgraham" wrote:

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.

Compare data in three fields
 

AWESOME! Thank you! Now . . . how do I use this to be able to add multiple
"IF" formula's? I'll try to explain. I have data in three columns that need
to be compared just as your formula allows, but then I also need to compare
data in multiple sets of three colums and have the max in each add to the
first formula? Have I confused you yet? Thanks again. Todd.


"David Biddulph" wrote:

In A4, =IF(A1=MAX(A$1:A$3),A1,"") and copy down to A5 and A6. I'm assuming
that you want the cell blank if the condition isn't satisfied. You haven't
said what you want if there is a tie for top spot.
--
David Biddulph

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

Compare data in three fields
 

Yes, you've confused me.
--
David Biddulph

"tssgraham" wrote in message
...
AWESOME! Thank you! Now . . . how do I use this to be able to add multiple
"IF" formula's? I'll try to explain. I have data in three columns that
need
to be compared just as your formula allows, but then I also need to
compare
data in multiple sets of three colums and have the max in each add to the
first formula? Have I confused you yet? Thanks again. Todd.

"David Biddulph" wrote:

In A4, =IF(A1=MAX(A$1:A$3),A1,"") and copy down to A5 and A6. I'm
assuming
that you want the cell blank if the condition isn't satisfied. You
haven't
said what you want if there is a tie for top spot.
--
David Biddulph

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