=IF(A1="","",ROUND(A1/7,0))


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Sean" wrote in message
oups.com...
dear all,

I want to paste the formula, but skip the blanks. Here is an example,

12 2 (=round(A1/7,0))
13 2
15 2
0
0
0
0
0
0
0

the second column is the formula. after calculating in B1 (round(A1/7,
0)), I copy B1 and then paste the whole B column. Instead of only
giving me 3 observations (B1~B3), excel also gives me zeros in the rest
of the cells. How do I ask excel not to paste these zeros?

Thank you for your help.

Sean