Formula text #DIV/0! Causing Problem

Posted by: kunal-mi-17 on 8 September 2017, 12:38 pm EST

  • Posted 8 September 2017, 12:38 pm EST

    <FONT face=Arial size=2>Hi,</FONT>

    <FONT face=Arial size=2>I am Facing a problem which is related to formula evaluation, I have a formula cell (Cell 3) which is something like Cell1/cell2. Here Cell1 and Cell 2 both have no values, that mean they have blank "" values in there cells. and hence the formula cell is evaluating to "#DIV/0!". </FONT>

    <FONT face=Arial size=2>Later when i am doing some calculation on any other cell say Cell 4 which is  based on the formula cell Cell 3 that in turn evaluates to #DIV/0! and hence the application behaves unexpectedly.</FONT>

    <FONT face=Arial size=2>Is there a way to remove the text #DIV/0! from the cell and putting a blank value. </FONT>

    <FONT face=Arial size=2>In the COM version 3.0 which i have used earlier this scenario would put a blank text in the formula cell and not #DIV/0!.</FONT>

    <FONT face=Arial size=2>Please Suggest.</FONT>

    <FONT face=Arial size=2>~Kunal</FONT> 

  • Replied 8 September 2017, 12:38 pm EST

    Kunal -

    This is the expected behavior.  If the cells values are null or an empty string then it will be evaluated to the #DIV/0! error.  One way to avoid this is explained in this post...

    If you do a search on #DIV/0! on the forums you will find many examples and explanations from bobbyo.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels