On Wed, 2 Feb 2005 16:27:01 -0800, "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…
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
|