Formula help

[Guest]

what I want to do is combine F2 and G2 (separated with a comma) if A2 and C2
match
If A2 and C2 do not match I want to combine H2 and I2 (separated with a comma)

is that possible in Excell?

 

[Dave Peterson]

No need to start a new thread.

what I want to do is combine F2 and G2 (separated with a comma) if A2 and C2
match
If A2 and C2 do not match I want to combine H2 and I2 (separated with a comma)

is that possible in Excell?

 

[Guest]

try this
=IF(A2=C2,F2&","&G2,IF(A2<>C2,H2&","&I2))

 

[Guest]

=IF(A2=C2,F2&","&G2,H2&","&I2)

 

[Stan Brown]

Sat, 21 Apr 2007 13:06:02 -0700 from joker_r_me

what I want to do is combine F2 and G2 (separated with a comma) if A2 and C2
match
If A2 and C2 do not match I want to combine H2 and I2 (separated with a comma)

is that possible in Excell?

I don't know what Excell might be, but you can do it in Excel. The
formula is


=if(A2=C2, F2&","&G2, H2&","&I2)