Forum Discussion

ChechoNajera's avatar
ChechoNajera
Qrew Member
3 years ago

Question about the round formula.

Hello guys :) 

I have a field with the number 4.2 and need it to round up to 4.5. 

The formula I am currently using is: 

Round([field],0.5)

But it's giving me 4.0 as an answer. 

I'm sure it's a very simple solution, but I can't figure it out. 

Any tips/help? Thanks! 



------------------------------
Checho Najera
------------------------------
Formulas and functions

5 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    np,
    use the Ceiling function

    Ceil([field],0.5)

    The opposite would be Floor([field],0.5) to always round down.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • ChechoNajera's avatar
      ChechoNajera
      Qrew Member
      3 years ago
      Thank you so much Mark! This worked perfect.

      ------------------------------
      Checho Najera
      ------------------------------
    • MichaelMurphree's avatar
      MichaelMurphree
      Qrew Member
      3 years ago
      Similiar question, I think, but I can't figure it out.

      We have services that we bill in "lots" of 10.  So if you need 6 of it, we bill for a quantity of 10.  If you need 11 of them, we bill for a quantity of 20.

      Any help on rounding to 10's instead of the next integer?

      ------------------------------
      Michael Murphree
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago
        Try this
        CEIL([my field], 10)

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------