ExcelBanter - dragging my formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - dragging my formula (https://www.excelbanter.com/excel-discussion-misc-queries/195725-re-dragging-my-formula.html)

rodchar

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

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