SharePoint Calculated Column Round Up

Copper Contributor

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. 

1 Reply
Figured it out !

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