Round up To The Nearest Hundred

[IJH34]

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

[alexnajm]

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)

[Felipe_Ribeir0 · Accepted solution]

Hi @IJH34 

One way of doing this is by using the ceil function