On the Seattle Inventory worksheet, in cell G14, enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should display OK. Copy the function down through cell G19.

Step by step instructions would be helpful as I do not understand the IF function completely.

File Home Insert Page Layout Formulas Formulas Data Review View Help Share Comments fx Calculate Now Insert Function ? A AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used Time Reference Trig Functions Function Library Define Name Use in Formula Name Manager E Create from Selection Defined Names Ex Trace Precedents Vfx Show Formulas a Trace Dependents Error Checking FRemove Arrows Evaluate Formula Formula Auditing Watch Window Calculation Options Calculate Sheet Calculation G14 : X A B D E F H I J K L $ 271.00 $ 24.77 $ 17.45 $ 2.99 $ 69.52 4 Total Items in Stock 5 Average Price 6 Median Price 7 Lowest Price 8 Highest Price 9 10 Ski Products 11 Ski Quantity in Stock 12 13 Quantity in Stock 14 2 Stock Level 15 16 Item # Item Name 32 115689 Deluxe Biking Shorts 78 114568 Vented Explorer 28 456897 Wicked Heavy Socks 58 465899 Gripper Gloves 57 465888 Airflow Hat 18 165332 Mini Crew Socks Retail Price Category 69.52 Pants 34.78 Hats 9.35 Socks and Gloves 25.55 Socks and Gloves 2.99 Hats 6.45 Socks and Gloves Sport Biking Hiking Skiing Skiing Hiking Fitness 17 18 19 20 21 22 Net Sales Net Sales by State Seattle Inventory Denver Inventory Inventory Summary Annual Expenses Sales Reps Ready + 100%