Try the Ceiling function.
Ceil([My Field])
Hey Mark,
Thanks so much for the help, that still didn't work, your suggestion worked but it only add a 1 to my 225 making is 226 which while it does round up, it doesn't exactly round up the way I need. It seems like the excel formula is making it a 22.5 and then rounding so we get the 23.
Thinking I might need to part out my number to add the decimal and then round it.
Jen
Qrew LegendCan you get me say 5 examples of the raw number and the result you want, then I'm sure I can come up with a formula. Are you saying you want to do exactly replicate the results from that Excel formula?
Hey Mark,
Thank you for the help your solution did work. I figured out that I missed the divide by 10 in my formula when I recreated it in Quickbase. That turned it my 225 to the 22.5 decimal in excel formula for the roundup to work.
IF(ROUNDUP((Q55/10),0)<5,5,ROUNDUP((Q55/10),0)),"")
Jen
