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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average rounded to nearest 0.50 4
rounding down to nearest 1/32 3
format to round down 2
Round Down to the nearest multiple 2
round up to nearest 50p 1
rounding up to nearest specified whole number 1
Round time up to nearest :15 2
Round time to nearest 15 minutes in decimal format 4

Top