Thread: Formula question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
joker_r_me[_2_] joker_r_me[_2_] is offline
external usenet poster
  
Posts: 6
Default Formula question
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

Reply With QuoteReply With Quote