| 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. |
| 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 | |||
Threaded Mode
