View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Earl
 
Posts: n/a
Default Multiple Range Formula

I want to evaluate a column that has multiple, and varied values. Then return
a value in multiples of '20' in another column. Where 0-19.99='20',
20-39.99='40', 40-59.99='60' etc.

Example:
Calculated Length Nominal Length
5.2 20
20.1 40
42.0 60
64.55 80