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.