software

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

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

quot;Earlquot; wrote:

gt; I want to evaluate a column that has multiple, and varied values. Then return
gt; a value in multiples of '20' in another column. Where 0-19.99='20',
gt; 20-39.99='40', 40-59.99='60' etc.
gt;
gt; Example:
gt; Calculated Length Nominal Length
gt; 5.2 20
gt; 20.1 40
gt; 42.0 60
gt; 64.55 80

=sumif(a:a,quot;lt;20quot;)

=SUMIF(A:A,quot;lt;40quot;)-SUMIF(A:A,quot;lt;20quot;)

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Earlquot; gt; wrote in message
...
gt; I want to evaluate a column that has multiple, and varied values. Then
return
gt; a value in multiples of '20' in another column. Where 0-19.99='20',
gt; 20-39.99='40', 40-59.99='60' etc.
gt;
gt; Example:
gt; Calculated Length Nominal Length
gt; 5.2 20
gt; 20.1 40
gt; 42.0 60
gt; 64.55 80