Round up field to nearest 500th

  • Resolved jambog82

    (@jambog82)


    7 years, 7 months ago

    I have a number field where users type a number to calculate a fee, but the fee is based on $500 increments, so if a user inputs $250, I need it to round the number up to $500. If it’s $2250 then round up to $2500, $2750 to $3000, etc.

    It is possible to do this?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello,

    Yes, with some of mathematic, if the field is fieldname1, the operation would be:

    CEIL(fieldname1/500)*500

    For example:
    CEIL(250/500)*500 = CEIL(0.5)*500 = 1*500 = 500
    CEIL(2250/500)*500 = CEIL(4.5)*500 = 5*500 = 2500

    and that’s all.

    Thread Starter jambog82

    (@jambog82)

    Awesome! It worked perfectly. Thank You! I am going to go leave your plugin a stellar review. It is an excellent plugin to have!

    Plugin Author codepeople

    (@codepeople)

    Thank you very much.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Round up field to nearest 500th’ is closed to new replies.