How do I replace the #DIV/0! with blanks in the cells?
I'd like to replace #DIV/0!
with a blank or a 0 in the cells that have this after I copy a formula to a range of cells. Replace doesn't recognize the symbol. |
Answer: How do I replace the #DIV/0! with blanks in the cells?
Hi there! I can definitely help you with that. Here's how you can replace the
Code:
#DIV/0!
That's it! Your cells should now display either a blank or a 0 instead of the Code:
#DIV/0! |
How do I replace the #DIV/0! with blanks in the cells?
To make your errors to your formulas not appear use the following
=if(iserror(your formula)," ",(type your formula again)) This should keep the cell blank until the right criteria is available for your formula to calculate. "wanttolearn" wrote: I'd like to replace #DIV/0! with a blank or a 0 in the cells that have this after I copy a formula to a range of cells. Replace doesn't recognize the symbol. |
How do I replace the #DIV/0! with blanks in the cells?
Change your formula to
=IF(ISERROR(Youpreviousformula),"",Youpreviousform ula) If you want zeroes, replace the double quotes with 0. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "wanttolearn" wrote: I'd like to replace #DIV/0! with a blank or a 0 in the cells that have this after I copy a formula to a range of cells. Replace doesn't recognize the symbol. |
How do I replace the #DIV/0! with blanks in the cells?
try using this
=IF(ISERROR(Your formula),"",Your formula) or =IF(ISERR(Your formula),"",Your formula) to place a 0 instead of blank, change "" to 0 HTH -- Appreciate that you click on the Yes button below if this posting was helpful. Thank You cheers, francis "wanttolearn" wrote: I'd like to replace #DIV/0! with a blank or a 0 in the cells that have this after I copy a formula to a range of cells. Replace doesn't recognize the symbol. |
How do I replace the #DIV/0! with blanks in the cells?
Rather than a blanket trap for all errors, which might hide a real problem,
better to look for divide by zero specifically. So if your formula is =A1/B1, change it to =IF(B1=0,"",A1/B1) -- David Biddulph "xlm" wrote in message ... try using this =IF(ISERROR(Your formula),"",Your formula) or =IF(ISERR(Your formula),"",Your formula) to place a 0 instead of blank, change "" to 0 HTH -- Appreciate that you click on the Yes button below if this posting was helpful. Thank You cheers, francis "wanttolearn" wrote: I'd like to replace #DIV/0! with a blank or a 0 in the cells that have this after I copy a formula to a range of cells. Replace doesn't recognize the symbol. |
All times are GMT +1. The time now is 12:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com