The abs formula

[JianLi]

I have two cells: C1=1.0000444, C2=1.0000333.
If I define a formula cell with formula "=ABS(c1-c2)", it return error "invalid Math argument". How to fix it?

[Administrator]

This is a bug in our code that we will fix. The problem occurs when the argument computes to a value that requires exponential notation to express it. In your sample, the value is roughly 1E-5.

To work around the until we publish an update with a fix, you can use an IF calculation instead of ABS to compute the absolute value of an expression.

=IF(c1-c2,c1-c2,c2-c1)