How to round a number to the nearest multiple of significance

Here is the problem:
How to convert this list of number to nearest multiple by 100?



I want to round number by suffix >= 50 --> 100 and <50> 0 and place the result in column B

Here is the solution:

I used 4 functions of MS Excel:

• Value: Converts a text string that represents a number to a number.
• Right: returns the last character or characters in a text string, based on the number of characters you specify.
• Ceiling: Returns number rounded up, away from zero, to the nearest multiple of significance
• Floor: Rounds number down, toward zero, to the nearest multiple of significance.

Result:




I used this function:
Select B1, type the formula below
=IF(VALUE(RIGHT(A1,2))>=50,CEILING(A1,100), FLOOR(A1, 100))




PS: I was using MS Excel 2007, may there are little differences with another version. You may change the number of significance (100) to 10, 50, 25 etc.

What do you think?