Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greater Than/Less Than Question (IF statement?) | Excel Worksheet Functions | |||
IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT | Excel Worksheet Functions | |||
Multiple Conditions for IF statement to evaluate | Excel Worksheet Functions | |||
Multiple Conditions Using Greater Than Less Than | Excel Discussion (Misc queries) | |||
"OR" operator to evaluate multiple conditions | Excel Worksheet Functions |