I just need help with the formula I need to use:

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 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". Copy the formula down through cell L38.

A B D G H M P S 1 Massage Item E Golf Item Food Item Projection Projection R Clothing Item Projection A2 Projection Novelty Item A13 A14 A9 4 A16 A1 41 2 3 4 5 5 Reading Item Projection A5 A7 A10 5 Projection 5 5 5 51 A3 4 6 A4 6 A17 A18 A19 A20 4 A15 A11 A12 7 6 6 A8 7 9 10 11 12 13 14 15 16 17 18 Item Description 19 A1 Healthy Trail Mix 20 A2 Resort Polo 21 A3 Healthy Energy Bar 22 A4 Spirits Lifted Through Yoga 23 A5 Golf Tees 24 A6 Max_On_Hand Wholesell Price Sale Price Category Delivery Time Current Inventory ReOrder_Point RushReOrderPoint Discontinue ReorderStatus Vendor 45) s 15.99 $ 21.99 Food 10 23 20 10 N Vendor 1 350 $ 29.48 $ 45.34 Clothing 14 15 17 10 N Vendor 2 25 $ 3.90 $ 9.95 Food 4 5 15 10 N Vendor 1 150 $ 6.90 $ 14.95 Reading 7 5 15 10 Y Vendor 4 50 $ 1.30 $ 2.59 Golf 11 27 20 101N Vendor 5 25 A7 26 A8 27 A9 28 A10 29 A11 30 A12 31 A13 32 A14 33 A15 34 A16 35 A17 36 A18 37 A19 38 A20 Inventory InventoryAudit DailyTransactions +