How do I round down to nearest .05% in Excel?

C

Chad

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.
 
B

Bob Phillips

=FLOOR(E1,1/2000)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

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)
 
C

CLR

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
 
Top