0

Round number field up to next 100?

What is the formula to round a number field up to the next 100 increment. Like 57 = 100, 223 = 300.

2 replies

null
    • Luck and Luck
    • Matthew_Luck
    • 3 yrs ago
    • Reported - view

    Hi,

    You could try...

    floor(number/100)*100 + 100

    Cheers Matt

    • Mr_K
    • 3 yrs ago
    • Reported - view

    I found a slolution alreay, but thanks Matt, I think your way works too. Here's my formula. It's designed to calculate UPS insurance cost for shipping. It works.

     

    if 'Ask Price' <= 100 then
    0
    else
    if 'Ask Price' > 100 and 'Ask Price' <= 300 then
    3.15
    else
    if 'Ask Price' > 300 then
    ceil('Ask Price' / 100) * 1.05
    end
    end
    end

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 615Views