188k views
5 votes
In cell G15, construct an IF function to determine the items that must be ordered. If the Quantity in Stock is greater than 75 the Value_if_true is Ok. Otherwise the Value_if_false is Order. Fill the formula down through all the row

User Radbyx
by
8.5k points

2 Answers

4 votes

Final answer:

To construct an IF function in cell G15 based on the Quantity in Stock, use the formula =IF(D15>75, "Ok", "Order").

Step-by-step explanation:

To construct an IF function in cell G15, you can enter the following formula:

=IF(D15>75,"Ok","Order")

This formula checks if the Quantity in Stock in cell D15 is greater than 75. If it is, the cell G15 will display "Ok", indicating that there is enough stock. If the Quantity in Stock is not greater than 75, the cell G15 will display "Order", indicating that more items need to be ordered.

You can then drag the formula down through all the rows to apply it to the entire column.

User TrongBang
by
8.0k points
3 votes

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

User Jimmy Kane
by
8.3k points

No related questions found