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

    Hi,


    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!".


    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.


    Is there a way to remove the text #DIV/0! from the cell and putting a blank value.


    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!.


    Please Suggest.


    ~Kunal 

  • 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...

    http://www.clubfarpoint.com/Forums/forums/post/25003.aspx

    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