divide by zero
Posted by gordon on July 30, 2001 5:04 PM
How do I trick the computer into dividing by zero. I need the zero because it has a value in my program.
I tried to replace #DIV/0! with 0 using the find and replace but Excel won't let me.
Posted by anno on July 30, 2001 5:20 PM
Not sure if this is what you want, but a quick and dirty way around this is to replace the #DIV/0! with a zero by using ISERROR(). For example, if the operation you have in cell A1 returns #DIV/0!, change the contents of A1 to "=IF(ISERROR(*),0)", where * is the operation you currently have in A1.
If you have a whole bunch of these to change in a non contiguous range this method will be a bit tedious, but like i said it's a quick and dirty way. over to the experts.
Posted by Aladin Akyurek on July 30, 2001 5:21 PM
You can't as far as I know.
:I need the zero because it has a value in my program.
Look at the formulas that return #DIV/0 and modify them to return 0. For example,
=IF(B1, A1/B1,0)
This will return 0 instead #DIV/0 when B1=0.
Aladin
=IF
