| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round numbers to get to the nearest 0.09
How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
I think this will do what you want...
=ROUND(A1,1)-0.01 -- Rick (MVP - Excel) "KB" wrote in message ... How do I round numbers to get to the nearest 0.09 (4.17=4.19 or 4.12=4.09) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
With a bit of playing around I came up with
=ROUND(A1,1) - 0.01 best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "KB" wrote in message ... How do I round numbers to get to the nearest 0.09 (4.17=4.19 or 4.12=4.09) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
=ROUND(A1,1)-0.01
"KB" wrote: How do I round numbers to get to the nearest 0.09 (4.17=4.19 or 4.12=4.09) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
On Mon, 23 Nov 2009 12:44:02 -0800, KB wrote:
How do I round numbers to get to the nearest 0.09 (4.17=4.19 or 4.12=4.09) =ROUND(A1+0.01,1)-0.01 --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
On Mon, 23 Nov 2009 15:57:58 -0500, "Rick Rothstein"
wrote: I think this will do what you want... =ROUND(A1,1)-0.01 -- Rick (MVP - Excel) Am I missing something? A1: 3.541 I would have thought: =ROUND(A1+0.01,1)-0.01 --ron |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
I think this will do what you want...
=ROUND(A1,1)-0.01 -- Rick (MVP - Excel) Am I missing something? A1: 3.541 I would have thought: =ROUND(A1+0.01,1)-0.01 No, you are not missing anything... adding the 0.01 to the value inside the ROUND function as you show in your post is the correct way to do this. -- Rick (MVP - Excel) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Round numbers to get to the nearest 0.09
On Mon, 23 Nov 2009 16:52:47 -0500, "Rick Rothstein"
wrote: No, you are not missing anything... adding the 0.01 to the value inside the ROUND function as you show in your post is the correct way to do this. -- Rick (MVP - Excel) Sometimes, in those hours between the start of cocktail time and dinner, I've been known to miss things :-) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
| how do I round a column of numbers to the nearest | Excel Worksheet Functions | |||
| How can you round numbers to the nearest quarter (i.e. .63=.75) | Excel Worksheet Functions | |||
| Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
| round numbers to the nearest quarter? | Excel Worksheet Functions | |||
Linear Mode
