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 Date]-[Date Created]),"NA",[Resolved Date]-[Date Created])
Any help is appreciated.
- batvan276Copper ContributorFigured it out !
=IF(ISERROR([Resolved Date]-[Date Created]),"NA",ROUNDUP([Resolved Date]-[Date Created],0))