Would an IF statement work for you?
=IF(A1=0,"",round(A1/7,0))
The formula will still occupy the cell, but nothing will be displayed
if the corresponding cell in column A is zero.
Sean Wrote:
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
--
Teodomiro
------------------------------------------------------------------------
Teodomiro's Profile:
http://www.excelforum.com/member.php...o&userid=33140
View this thread:
http://www.excelforum.com/showthread...hreadid=530604