Help

Is there any way to round up these qauntities?

Topic Labels: Formulas
Solved
Jump to Solution
683 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!