JenniferSilbers

21 days agoQrew Trainee

# Roundup whole number

Hello,

I need help with rounding up a whole number in Quickbase.

My formula in Excel is =IF(ISNUMBER(D59),IF(ROUNDUP((Q55/10),0)<5,5,ROUNDUP((Q55/10),0)),"")

Round doesn't work when the number from the formula in Quickbase is over 100 or larger.

I want to be able to take something like 2,250/10 = 225(Q55 in formula above) and have QB give me 23. If I put in 1 in my formula it would give me 5. 1/10=.1 returns 5.

Thanks in Advance.

Jennifer

Try the Ceiling function.

Ceil([My Field])