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.

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.

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.

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.

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.