Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste formula and skip blanks
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste formula and skip blanks
=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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste formula and skip blanks
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste formula and skip blanks
=IF(A10,(ROUND(A1/7,0)),"")
This formula will not display a 0 if A1 is empty so you can copy and paste down If you want to not include a formula at at you can use a macro. If you want you can send me an example sheet and I will send you a macro example of how else to fix it -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200604/1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste formula and skip blanks
Thank you guys for your help! It works!!
Sean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy paste formula to skip rows | Excel Worksheet Functions | |||
How can i get a IF formula to skip to the next reference box | Excel Worksheet Functions | |||
I want to copy a formula n Excel but skip any blank cells | Excel Worksheet Functions | |||
formula in excel to skip cells having - number and add only + | Excel Worksheet Functions | |||
Skip multiple blanks | Excel Discussion (Misc queries) |