Rounding Numbers

I have a list of values as below:

476.14
361.99
345.69
463.08
515.29
403.44
330.68
347.64
375.36

I would like to create a formula that rounds the values to the nearest 0.05
eg. Round 476.14 to 476.15, 361.99 to 362.00, 375.36 to 375.35 etc…
Is there anyway that I can do this?

Thanks, Jane.

JaneC wrote:
> I have a list of values as below:
> 476.14
> 361.99
> 345.69
> 463.08
> 515.29
> 403.44
> 330.68
> 347.64
> 375.36
> I would like to create a formula that rounds the values
> to the nearest 0.05 eg. Round 476.14 to 476.15,
> 361.99 to 362.00, 375.36 to 375.35 etc...
MROUND(number, multiple)

For example, =MROUND(A1, 0.05)

On Wed, 2 Feb 2005 16:27:01 -0800, "JaneC" <[email protected]>
wrote:

>I have a list of values as below:
>
>476.14
>361.99
>345.69
>463.08
>515.29
>403.44
>330.68
>347.64
>375.36
>
>I would like to create a formula that rounds the values to the nearest 0.05
>eg. Round 476.14 to 476.15, 361.99 to 362.00, 375.36 to 375.35 etc…
>Is there anyway that I can do this?
>
>Thanks, Jane.

=ROUND(A1/0.05,0)*0.05

where A1 is the cell reference containing your number.

Format the result as Number with 2 decimals (Format/Cells/Number Number
Decimals 2)


--ron