Posted to microsoft.public.excel.misc

sgausti

Posts: n/a

Copy an "if" Statement

I have a simple formula =IF(C2<C3,1," "). This formula works perfectly when
I type it in. I have a spreadsheet with over 10000 lines and want to copy
this formula down. When I copy the formula and paste it, it no longer gives
me the correct output. What can I do?

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
Return blank for true "if" statement when charting, not 0	Jay F	Charts and Charting in Excel	1	June 21st 06 04:15 PM
Using COPY with an IF formula	burnsbyrne	Excel Discussion (Misc queries)	2	May 19th 06 06:02 PM
How can I copy cell formats in functions?	Twitty Kitty	Excel Worksheet Functions	3	July 24th 05 12:26 AM
Copy Function	Genie Bohn	Excel Discussion (Misc queries)	0	March 23rd 05 12:28 AM
Copy and pasting graphs to PowerPoint	JZip	Excel Discussion (Misc queries)	0	January 6th 05 08:29 PM

All times are GMT +1. The time now is 07:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us