View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GreenMonster[_2_] GreenMonster[_2_] is offline
external usenet poster
 
Posts: 10
Default Rounding up to the nearest 6" increment

I need a function that rounds a number up to the nearest 6" increment

In other words, if the number to be rounded is 19" the value returned would
be 24". If the number is 20" the value returned would also be 24".

To complicate matters, if the number to be rounded up is less than or equal
to 2" then the the returned value needs to be then 2nd nearest 6" increment.

In other words, if the number to be rounded is 17" or 16" then the returned
value needs to be 24". 15" would round to 18", as would 14, 13, and 12. 10
and 11 would also round to 18".

Make sense? Hope so.

Thanks