Using IF statement to evaluate Greater or Less than Conditions
 

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.

Using IF statement to evaluate Greater or Less than Conditions
 

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

"Shams" wrote:

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.

Using IF statement to evaluate Greater or Less than Conditions
 

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)

--
Kevin Backmann


"Shams" wrote:

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.