View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay3253 Jay3253 is offline
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