Using IF statement to evaluate Greater or Less than Conditions

[Shams]

Hello Folks,
I have the following Scenario:

If Inventory is < 120, write off 20%
If Inventory is > 120 but less than 360, write off 50%
If Inventory is > 360, write off 100%

Using a nested loop, I am trying to capture all the scenarios. Right now, I
am getting stumped on inventory between 120 and 360. Because of the way I
have it set up now, it is writing off 50% for even > 360 days inventory since
the earlier condition to that says greater than 120 days.

How can I get around this situation? Any help is appreciated!

Regards,
Shams.

 

[Shams]

Folks,
I think I found my simple solution. I just changed the second IF statement
to say < 360.

 

[Kevin B]

Create a lookup table similar to the one below
Inventory Percentage
0 20%
121 50%
361 100%

=VLOOKUP(Value to Lookup, Table_Location,Offset)

If the value is in A1 and the table is in AA1:AB3 then the VLOOKUP would be
as follows

=VLOOKUP(A1,$AA$1:$AB$3,1)