Formula question

[Guest]

What's wrong with this formula?

=IF(A2=C2,(F2:G2),(H2:I2))

all columns referenced are numbers.
I'm trying to say if A2=C2 then insert F2-G2 columns
but if A2 doesn't = C2 then insert H2-I2 columns

 

[JE McGimpsey]

There's nothing wrong if you're array-entering it (using
CTRL-SHIFT-ENTER) into two adjacent cells.

 

[Guest]

I'm not sure what your trying to do but the answer to your question is that
your formula doesn't do anything if A2=C2 is true or false because (F2:G2)
isn't actually an instruction to do anything. You might try:-

=IF(A2=C2,SUM(F2:G2),SUM(H2:I2))

Mike

 

[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]

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

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]

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

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

 

[Dave Peterson]

Thanks for the typo correction.

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