Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Is there any way to round up these qauntities?

Topic Labels: Formulas
Solved
Jump to Solution
1201 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_Farrell
5 - Automation Enthusiast
5 - Automation Enthusiast

Is it possible to round up those really long decimals?
Thank you!
please_help

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Try

ROUND(Boxes Available, 2) & ' '& {Shipped In/On Plural}

^ the 2 means 2 decimal places, so 2.6999999 would be 2.7

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Try

ROUND(Boxes Available, 2) & ' '& {Shipped In/On Plural}

^ the 2 means 2 decimal places, so 2.6999999 would be 2.7

That worked! Thanks a bunch friend!