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