Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Is there any way to round up these qauntities?

Topic Labels: Formulas
Solved
Jump to Solution
172 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

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!