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

Posted to microsoft.public.excel.misc

Chad

Posts: n/a

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

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
unhide menu bar in excel - just disappeared	Sean	Setting up and Configuration of Excel	12	April 4th 23 10:19 AM
How do I tell a price list to round up and down to the nearest 25	Philippa	Excel Worksheet Functions	2	January 12th 06 12:57 PM
Formula to enter to round an Excel value up to the next $0.5?	Lee	Excel Discussion (Misc queries)	1	January 4th 06 10:51 PM
I need to round up to the nearest 50.	karenm	Excel Discussion (Misc queries)	3	September 13th 05 03:31 PM
In Excel, how do you get it to not automatically round my dollars.	Cylie G.	Excel Worksheet Functions	2	January 7th 05 10:43 PM

All times are GMT +1. The time now is 03:47 PM.

About Us