Why result from GridWeb Formula Error?

Aspose.Cells Product Family
1

My Excel File cell C1 Formula =IF(A1=0,0,B1/A1)

A1=2,B1=6 -----> C1=3 result correct
A1=0,B1=6 -----> C1=#DIV/0? result Error * C1 should be =0

(Condition IF Check A1=0 C1 should be =0 )

Please Solve it.

2

Hi,

We have confirmed that it's caused by a internal bug. We will fixed it and provide a new version soon.

Thank you.

3

Hi,

See attachment file.

4

Thank you for gridweb new version .

Now Formula result correct.