Thread: How do I round down to nearest .05% in Excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote