Formula help
 

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?

Formula help
 

No need to start a new thread.

joker_r_me wrote:

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

Formula help
 

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

"joker_r_me" wrote:

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?

Formula help
 

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

"joker_r_me" wrote:

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?

Formula help
 

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)
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/