Embeded IF - between ranges

[Emily]

Using Excel 3. I am trying to assign ABC codes to long list of products
based on % of sales.

A10 is part #, B10 is %. In C10, need formula to pick a code from following
table. The table changes periodically.

Code A=over 80%
Code B=between 60 and 80%
Code C=between 40...60%
Code D = less than 40%

 

[T. Valko]

The table changes periodically.

Create a 2 column table like this...

0%...D
40%...C
60%...B
80%...A

Assume the table is in the range J2:K5

Then...this formula entered in C10 and copied down:

=LOOKUP(B10,J$2:K$5)

 

[Ashish Mathur]

Hi,

After arranging the table as mentioned in the previous post, you may also
use this formula

=VLOOKUP(B10,J$2:K$5,2,1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com