automated classification

[Bax]

Hi all,

I'm struggling with the following issue. I'll try to explain as simple as possible..

I have a column D with partnumbers, a column E with units per partnumber and a column F with a classification. This particular column needs to be filled automatically.
Column A and B are the criteria for that classification.

I have 3 classifications, A (250.000 units), B (100.000 units) and C (50.000 units).
All parts with a cumulated qty of up to 250.000 needs to get classification A.
All parts with a cumulated qty between 250.000 and 350.000 units (A + B) needs to get classification B.
All parts with a cumulated qty between 350.000 and 400.000 units (A + B + C) needs to get classification C.

How can I get column F filled with the respective cell value in A2, A3 or A4, based on their qty in column E?

Many thanks in advance for your time and effort!!

Kind regards
Peter

[alansidman]

I looked at your spreadsheet and I cannot determine how you derived the classifications in column F. They do not appear to relate to the information in the thread above and they do not appear to relate to cells A2, A3 and A4. Please clarify your logic.

[Bax]

Hi Alan,

The classifications are calculated as follows:
Part 1 has a qty of 100000 (is < 250000 (value B2), so classification A)
Part 2 has a cumulated qty of 100000 (part 1) + 90000 = 190000 (is < 250000, so classification A)
Part 3 has a cumulated qty of 190000 (part 1+2) + 45000 = 235000 (is < 250000, so classification A)
Part 4 has a cumulated qty of 235000 (part 1+2+3) + 35000 = 270000 (is > 250000, but within range of 350000 (classification A + B), so classification B)
all next parts will have classification B up to a cumulated qty of 350000. All parts after that, receive classification C.

I hope it makes a bit more sense now... if not, please let me know!!

Thanks again for your assistance!!
Kind regards
Peter