Dear All,
I hope you're all well.
I hope you can help me on a simple formula or function.
I am struggling to sort this and I can't find it.
What I need to know is how to round decimal numbers with the following criteria.
If decimal number is =<0.05, I want the result of 0.05 (e.g. if I have a value of "1234.02" I want a formula to change the value to "1234.05")
If decimal number is >0.05, I want the result of 0.10 (e.g. if I have a value of "1234.06" I want a formula to change the value to "1235.10")
Your assistance will be highly appreciated.
Best regards,
Filipe
Bookmarks