ROUND function returns wrong result

[gvg]

I keep getting this strange message which does not sound reasonable given the number supplied is decimal. In math you can round any number to any number of decimal places. It can't be "too large" or "too small".

An argument of function 'ROUND' has the wrong data type or the result is too large or too small.

[v-yingjl]

Hi @gvg ,

Consider whether there is blank value in it or use Iferror like this:

ROUND(IFERROR(...,0),2)

In addition, consider whether the whole formula has the clear context, similar issue:

1. error refreshing from live database 
2. An Argument of Function Date has wrong data type or result is too small or too large 
3. Error:An argument of function 'DATE' has the wrong data type or the result is too large or too small 

Best Regards,
Community Support Team _ Yingjie Li