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

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

In article ,
joker_r_me wrote:

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

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

"joker_r_me" wrote:

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

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?

=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?

--

Dave Peterson

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

"Dave Peterson" wrote:

=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?

--

Dave Peterson

Thanks for the typo correction.

Mike wrote:

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

"Dave Peterson" wrote:

=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?

--

Dave Peterson


--

Dave Peterson