Round Decimal Values using Formulas and/or Functions

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

Try this:

Formula:

Please Login or Register  to view this content.

Thanks for your fast reply zbor,

I tried on a value of "3.04" and showed up as "310".

I need it to show as "3.05".

Thanks a million in advance.
Filipe

Sorry, forgot to divide back:

Formula:

Please Login or Register  to view this content.

Almost there zbor

It shows now "3.10" but not "3.05".

Basically, if the decimal number is equal or less than x.x5, I want it to show as x.x5. If it more than x.x5, I want the value as x.10

Thanks a million.

Cheers.

Hi Daddylonglegs,

Thanks a million.

That was exactly what I was looking for.

Never heard about that formula before.

Really appreciated.

Have a nice day
Filipe