| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I round down to nearest .05% in Excel?
I have a column of %'s that I need to round DOWN to the nearest .05%. So,
1.24% goes down to 1.20%. I do have the Analysis ToolPak. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round down to nearest .05% in Excel?
=FLOOR(E1,1/2000)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Chad" wrote in message ... I have a column of %'s that I need to round DOWN to the nearest .05%. So, 1.24% goes down to 1.20%. I do have the Analysis ToolPak. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round down to nearest .05% in Excel?
Maybe....
=FLOOR(A1,0.05) Vaya con Dios, Chuck, CABGx3 "Chad" wrote: I have a column of %'s that I need to round DOWN to the nearest .05%. So, 1.24% goes down to 1.20%. I do have the Analysis ToolPak. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round down to nearest .05% in Excel?
Chuck,
I like your version more than mine, but if it is percentage, I think it should be =FLOOR(A1,0.0005) or even better as I just discovered =FLOOR(A1,0.05%) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Maybe.... =FLOOR(A1,0.05) Vaya con Dios, Chuck, CABGx3 "Chad" wrote: I have a column of %'s that I need to round DOWN to the nearest .05%. So, 1.24% goes down to 1.20%. I do have the Analysis ToolPak. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round down to nearest .05% in Excel?
Yup, you're probably correct Bob. I don't have Excel up and running here
right now, so I can't test anything, but usually by taking your word for something, I wind up being right <g.... Vaya con Dios, Chuck, CABGx3 "Bob Phillips" wrote in message ... Chuck, I like your version more than mine, but if it is percentage, I think it should be =FLOOR(A1,0.0005) or even better as I just discovered =FLOOR(A1,0.05%) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Maybe.... =FLOOR(A1,0.05) Vaya con Dios, Chuck, CABGx3 "Chad" wrote: I have a column of %'s that I need to round DOWN to the nearest .05%. So, 1.24% goes down to 1.20%. I do have the Analysis ToolPak. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| How do I tell a price list to round up and down to the nearest 25 | Excel Worksheet Functions | |||
| Formula to enter to round an Excel value up to the next $0.5? | Excel Discussion (Misc queries) | |||
| I need to round up to the nearest 50. | Excel Discussion (Misc queries) | |||
| In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
Linear Mode
