We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

The abs formula

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?

1 Reply

AD Administrator Syncfusion Team March 16, 2004 03:49 AM

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)

Loader.
Live Chat Icon For mobile
Up arrow icon