Help

Re: Roundup Formula Error

453 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Leno_Marin
5 - Automation Enthusiast
5 - Automation Enthusiast

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)