LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
adodson
 
Posts: n/a
Default MRound and Roundup

I can't seem to get these functions to work in conjunction with each other to
get my desired results, so I'm putting it out there for someone else's great
mind. Thanks in advance for any assistance.

I would like it to look at a number and always round up to the nearest
multiple of 5. For example,
1069 would change to 1070
1062 would change to 1065

Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"