What is the formula to round a number field up to the next 100 increment. Like 57 = 100, 223 = 300.
You could try...
floor(number/100)*100 + 100
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
if 'Ask Price' > 100 and 'Ask Price' <= 300 then
if 'Ask Price' > 300 then
ceil('Ask Price' / 100) * 1.05