On the Inventory worksheet, in cell L19, 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 119 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 (119). If the value is true, return "Reorder". If the value is false, return "OK". Copy the formula down through cell L38