How to Round the last 3 digits.

[svelma]

Hi,

I need to round up the last 3 digits. If the last two digits are >=50 then I need it rounded to the next hundred and if the last two digits are <50 then I need it rounded to the previous hundred.

For example:

If I have 22,560 in A1, then the formula in B1 should give me 22600.
If I have 22,540 in A1, then the formula in B1 should give me 22500.

Thank you very much,
Velma

 

[barry houdini]

To round to the nearest 100

=ROUND(A1,-2)

 

[svelma]

Thank you Barry. That was very helpful. Have a great day.