Posted 8 September 2017, 12:38 pm EST
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!.