Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
It looks like a silly question, but I couldn't find an answer and wasn't able to work it around myself, so:
How can I dynamically round a number, so that the final value is first two digits of the number plus 1 and the rest are zeroes:
| Initial | After rounding |
|---|---|
| 12345 | 13000 |
| 123 | 130 |
| 9987 | 10000 |
| 5 | 10 |
Would appreciate any help
Thanks
That makes sense, I should have thought about that.... but glad you were able to figure it out.
Best,
Sunny