Formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
No need to start a new thread.

joker_r_me said:
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?
Click to expand...
 
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?
Click to expand...

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)
 
Back
Top