Final answer:
To construct the required IF function in cell G15, use the formula: =IF(D15>75, "Ok", "Order"). Drag the formula down to apply it to all rows.
Step-by-step explanation:
To construct the required IF function in cell G15, you can use the following formula: =IF(D15>75, "Ok", "Order"). This formula checks whether the quantity in stock in cell D15 is greater than 75. If it is, the result will be "Ok", indicating that the items do not need to be ordered. Otherwise, the result will be "Order", indicating that the items should be ordered.
To fill the formula down through all rows, you can simply drag the cell G15 downwards. This will automatically apply the formula to all the cells below, adjusting the cell references accordingly.
Learn more about IF function in Excel