Forum Discussion

JenniferSilbers's avatar
JenniferSilbers
Qrew Trainee
13 days ago

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

formulas
    • JenniferSilbers's avatar
      JenniferSilbers
      Qrew Trainee
      12 days ago

      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

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        12 days ago

        Can 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?