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
|