Forum Discussion

hawkins56671's avatar
hawkins56671
Copper Contributor
Sep 22, 2017

Multiple Nested IF functions with additional AND functions

HERE IS WHAT I AM WORKING ON BUT I REALLY JUST NEED AN EXAMPLE OF HOW PROPERLY INPUT THE INFORMATION. I DONT UNDERSTAND HOW THESE TWO FUNCTIONS WORK TOGETHER. 

Enter nested IF and AND functions to determine the reorder status. 
For the logical test, determine if the current inventory in cell H19 is blank and the reorder point in I19 is blank. If the value is true, return a blank.

But if the value is false, nest a second nested IF and AND function in which the logical test determines if the Discontinue in K19 is equal to "N" and the Current Inventory is less than or equal to the rush reorder point in J19. If the value is true, "Rush" should be returned. If the value is false, then nest a third IF and AND function in which the logical test determines if Discontinue (K19) is equal to "N" and Current Inventory (H19) is less than the Reorder Point (I19). If the value is true, return "Reorder". If the value is false, return "Ok".

  • CARLOS ADRIAN's avatar
    CARLOS ADRIAN
    Copper Contributor

    I hope it helps

     

    =IF(AND(ISBLANK(H19),ISBLANK(I19)),"",IF(AND(K19="N",H19<=J19),"Rush",IF(AND(K19="N",H19<I19),"Reorder","OK")))

Resources