=(1+int(value/20))*20

"Earl" wrote:

> 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