Coddie

Posts: n/a

How do you copy a cell formula down a column without displaying n.

I want to insert a formula into my worksheet and copy it down the column
without displaying anything in each cell until a value is established.
Example would be
A3-A2+A1 would be the formula I want the answer to show up in cell A4. I
want to copy the formula from A5 down to A25, but I don't want the result of
cell A4 to show up in each cell.

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
When I copy down into the next cell the formula changes correctly.	Jason30	Excel Discussion (Misc queries)	1	January 12th 05 11:55 PM
to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i .	bvi	Excel Worksheet Functions	3	December 23rd 04 06:14 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Copy formula to every 12th cell	Jerry Derfler	Excel Worksheet Functions	3	November 14th 04 11:09 PM
How to populate column with formula based on value in cell	Cameron Stewart	Excel Worksheet Functions	2	November 2nd 04 01:36 AM

All times are GMT +1. The time now is 01:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us