| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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) |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Rounding numbers up or down | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Linear Mode
