maluli

Posts: n/a

Rounding a number down to the nearest 5?

I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290.

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
Rounding numbers up or down	boyshanks	Excel Discussion (Misc queries)	13	April 8th 09 03:03 PM
Rounding to the nearest 9th	Corby	Excel Discussion (Misc queries)	16	November 13th 07 10:28 AM
How do I keep a value from rounding up to the next number?	Abby	Excel Worksheet Functions	1	January 5th 05 09:07 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Rounding a number to a multiple quantity that adds to a fixed total number	wjlo	Excel Worksheet Functions	1	November 9th 04 04:43 PM

All times are GMT +1. The time now is 02:20 AM.

About Us

"It's about Microsoft Excel"