Posted to microsoft.public.excel.misc

rodchar

external usenet poster

Posts: 80

dragging my formula

thanks everyone for the help,
rod.

"rodchar" wrote:

hey all,
a1,b1
1,1

a2,b2
" " , " "
a3,b3
2,2

let's say in the C column i want to add 3 to all the values in the A column.
I select cell C1, type =A1 + 3 and then start dragging down to row3.

Since the value in row2 is blank is there a way to omit that from just
placing a 3 there?

thanks,
rodchar

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Dragging Down a Formula	JBoyer	Excel Worksheet Functions	4	July 3rd 08 12:57 PM
Dragging formula	Sasikiran	Excel Discussion (Misc queries)	8	November 15th 07 11:01 PM
dragging a formula down a column	Jason R	Excel Worksheet Functions	4	December 13th 05 01:01 AM
when dragging formula how do i avoid #DIV/0!	derwood	Excel Discussion (Misc queries)	3	November 5th 05 07:44 AM
dragging a formula	P Bates	Excel Discussion (Misc queries)	3	August 7th 05 09:37 PM

All times are GMT +1. The time now is 10:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us