Round up To The Nearest Hundred

While I know the answer is right in front of my face, I'm struggling to find a solution.

I am looking for a formula that will always round a value up to the nearest 100. Tried CEIL function but that just give me nearest integer.

see results below...

original value	expected value
10000	10000
5678	5700
4142	4200
629	700

Datasets

Preparation

Expression

Accepted answers

One way of doing this is by using the ceil function

All comments

I would look at the ROUND function! Something like ROUND([Field],100) and putting some logic in to say anything under fifty needs to make sure to round up?

(apologies for not having a workflow, on my phone only today)

One way of doing this is by using the ceil function

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703