+5I’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.
@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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.