Forum Discussion

batvan276's avatar
batvan276
Copper Contributor
Mar 09, 2021

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. 

  • batvan276's avatar
    batvan276
    Copper Contributor
    Figured it out !

    =IF(ISERROR([Resolved Date]-[Date Created]),"NA",ROUNDUP([Resolved Date]-[Date Created],0))

Resources