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

Roundup Formula Error

Topic Labels: Formulas
603 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to ROUNDUP() the value of a “Wall Width” / “Usable Roll Width” but I’m getting an error in the formula. See screenshot here: UGH why can’t I upload a screen shot!!

t’s a very straight forward formula and I can’t figure out why it’s not rounding up to 4, in this case.

1 Reply 1

@Leno_Marin what does your formula look like? Can you post it here surrounded by three backticks on either side (```) so we can see what you have in the ROUNDUP() function?

Are you making sure to provide a precision value to the function? If you want to round to a whole integer, like 4, you’ll want to provide 0 as the precision value:

ROUNDUP({Wall Width} / {Usable Role Width}, 0)