dragging my formula

[rodchar]

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

 

[JasonP CCTM LV]

After dragging down, go through and delete the formula from that cell.

 

[John C]

in cell C1, type the following:
=IF(ISNUMBER(A1),A1+3,"")

And copy down as needed.

Hope this helps.

 

[M Kan]

=IF(isblank(a1),"",A1+3)

 

[rodchar]

thanks everyone for the help,
rod.