SharePoint Calculated Column Round Up

%3CLINGO-SUB%20id%3D%22lingo-sub-2196316%22%20slang%3D%22en-US%22%3ESharePoint%20Calculated%20Column%20Round%20Up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2196316%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20calculated%20column%26nbsp%3B%20that%20is%20showing%2015%20decimal%20places%20.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%20round%20up%26nbsp%3B%3CEM%3E%3CSTRONG%3E0.718437499999709%20to%20display%201%3F%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20current%20formula%20%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(ISERROR(%5BResolved%20Date%5D-%5BDate%20Created%5D)%2C%22NA%22%2C%5BResolved%20Date%5D-%5BDate%20Created%5D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2196316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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))