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 |
Solved! Go to Solution.
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)