LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Round to numbers in a list

I have an quation that gives me a number for the size of a steel rod.
The steel rods we use are only certain sizes so not just any size wil
do. The rod size I get in this equation I would like it to look at
list of the correct rod sizes and round up to the next size on the lis
we use.

NOTE: The sizes we use are not uniform so there is NOT an equa
distance between rod sizes.

Thank you
Jaso

--
Message posted from http://www.ExcelForum.com

 
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 numbers in the millions to numbers in the thousands Little Red Excel Worksheet Functions 2 June 26th 08 08:51 PM
Round numbers up or down and always end in an 8 jpizel Excel Worksheet Functions 3 March 8th 08 03:38 PM
I am trying to round a list of numbers (prices) to xx.95. Is the Comexe35 Excel Worksheet Functions 3 February 3rd 06 01:49 PM
How to Round Whole Numbers? blank Excel Discussion (Misc queries) 3 May 18th 05 09:32 AM
Can you round numbers to display a specific set of numbers, for e. lbfries Excel Discussion (Misc queries) 3 April 20th 05 09:52 PM


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

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"