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