ExcelBanter - Multiple Range Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple Range Formula (https://www.excelbanter.com/excel-worksheet-functions/75211-multiple-range-formula.html)

Earl

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

Duke Carey

Multiple Range Formula

=(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

Bob Phillips

Multiple Range Formula

=sumif(a:a,"<20")

=SUMIF(A:A,"<40")-SUMIF(A:A,"<20")

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Earl" wrote in message
...
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

All times are GMT +1. The time now is 10:23 PM.