The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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?
ADAdministrator Syncfusion Team March 16, 2004 08:49 AM UTC
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)