LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 32
Default Round to a particular tolerance

Hi All,

Is there a way to round to an even numbers, or odd. It doesn't really
matter. Basically this is what I need:

120=120
121=120
121.999=120
122=122
123=122
124=124
125=124
126=126
127=126
128=128
129=128
130=130

or maybe even change it later to
120 to 122.999 = 120
123 to 125.999 = 123
etc...

the one catch is, it must round down to that number. When I looked at
'rounddown' it only rounds to 1, 10, 100 etc. unless I am wrong

thanks
Chad


 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
@ROUND steph44haf Excel Worksheet Functions 4 October 23rd 06 02:06 PM
exel conditional formula,calculate a bilateral tolerance(.2/-.2)? Jorge Excel Discussion (Misc queries) 1 May 11th 06 03:55 AM
Tolerance Stack Excel Worksheet MTUSNOW Excel Discussion (Misc queries) 0 September 7th 05 11:05 PM
Changing the color of a list entry based on a tolerance Blink Excel Worksheet Functions 1 July 15th 05 05:18 PM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 10:50 AM


All times are GMT +1. The time now is 05:25 PM.

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

About Us

"It's about Microsoft Excel"