Convert number to nearest multiple of Five

Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Convert number to nearest multiple of Five

Hello,

Is there a way that I can convert a number to its nearest multiple of
5?

like in A1.. A5 i have

281
288
291
297
298

I want in B1 .. B5

280
290
290
295
300

That is up the number or down to nearest multiples of five

Thanks

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
how to correct the decimal number to the nearest even number	santosh kutre	Excel Worksheet Functions	3	November 3rd 08 04:04 PM
convert Inches to the nearest foot	Mario454	Excel Discussion (Misc queries)	2	July 2nd 08 03:10 AM
Excel. How to round a number to nearest half number?	HaraldS	Excel Discussion (Misc queries)	2	February 19th 07 09:50 AM
How do I convert time to the nearest 1/4 hour with a 7 min. window	Bigbus	Excel Worksheet Functions	4	August 28th 06 03:09 PM
how do I convert numbers to the nearest 1000	Brian	Excel Discussion (Misc queries)	2	February 8th 06 12:36 AM

All times are GMT +1. The time now is 07:12 PM.

Menu

About Us