Posted to microsoft.public.excel.misc

joker_r_me[_2_] joker_r_me[_2_] is offline

external usenet poster

Posts: 6

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Question	metaltecks	Excel Discussion (Misc queries)	3	December 6th 06 05:24 PM
formula question	Problems with formula within worksheet	Excel Discussion (Misc queries)	4	November 29th 06 12:25 AM
question on formula	Cokeyb	Excel Discussion (Misc queries)	2	June 22nd 06 08:08 PM
Newbie Question - Subtraction Formula Question	[email protected]	Excel Discussion (Misc queries)	3	May 5th 06 05:50 PM
Formula Question	metaltecks	Excel Discussion (Misc queries)	1	May 4th 06 06:02 PM

All times are GMT +1. The time now is 02:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us