assiging categories

N

nadeem98

I would like to assign a categry based on certain criteria. The
criteria is set up on a diffrent sheet. I would like to have a
function/formula to compare the data in the criteria and assign the
category. For example i have to assign the categories based on monthly
usage to the parts.

Data:
Part No Usage Category
AAA 50 A1
BBB 30 A2
CCC 25 A3



Criteria:

Usage greater than 30.........> A1
Usage greater than 25.........> A2
Usage lower than 25.........> A3

How i can do this by excel function. Response would be greatly
appreciated
 
P

Pete_UK

If the criteria is set up on a different sheet, then you could use a
VLOOKUP formula, but for what you describe you could use this in C2:

=IF(B2>30,"A1",IF(B2>25,"A2","A3"))

and then copy down as required.

Hope this helps.

Pete
 
Top