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.