adding a decimal to a date does not round up

MarkCep
✭✭✭✭✭
I have a field that is calculating the average of days, which comes in as a decimal. When I go to add this decimal number to a date to get a future date, it only uses the whole number of the decimal, and if the decimal number is 15.94, it only uses the 15. Why would it not use 16?
Tags:
Answers
-
have you tried a roundup function? Not sure why it uses the 15.
-
I could use the round up, but trying to understand why it uses the 15.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!