Round number field up to next 100?
Ninox Profile

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

M

Hi,

You could try...

floor(number/100)*100 + 100

Cheers Matt

Ninox Profile

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

Reply