Forum Discussion
batvan276
Mar 09, 2021Copper Contributor
SharePoint Calculated Column Round Up
Hello, I have a calculated column that is showing 15 decimal places . Can someone help me round up 0.718437499999709 to display 1? This is the current formula ; =IF(ISERROR([Resolved...
batvan276
Mar 09, 2021Copper Contributor
Figured it out !
=IF(ISERROR([Resolved Date]-[Date Created]),"NA",ROUNDUP([Resolved Date]-[Date Created],0))
=IF(ISERROR([Resolved Date]-[Date Created]),"NA",ROUNDUP([Resolved Date]-[Date Created],0))