JenniferSilbers
3 months 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])