Round Values

[darson.timmm]

Hello everyone!

We have a list of prices and we want to round the prices and apply specific rules to the intervals.

If price finishes with numbers in interval of 0-2,5, the price has to be rounded to 0
If price finishes with numbers in interval of 2,5-7 then it has to be rounded to 5
If price finishes with numbers in interval of 7,01-9,99 it has to be rounded to 0 (bigger value)

Thank youuu!!!

 

[NARAYANK991]

Hi ,

See if this is what you want.

Narayan

 

[John Jairo V]

Hi!

You can use this formulae (if you have the number in A1):
=MROUND(A1+0.5*(MOD(A1/10,1)>0.7),5)

Blessings!

 

[darson.timmm]

Hi ,

See if this is what you want.

Narayan

YOU ARE AMAZING! Thank you! Have a great day!

 

[darson.timmm]

Hi!

You can use this formulae (if you have the number in A1):
=MROUND(A1+0.5*(MOD(A1/10,1)>0.7),5)

Blessings!

Will try it as well! Thank you!