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/