Question: In cell G 1 5 , construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less

In cell G
1
5
,
construct an IF function to determine the items that must be ordered. If the Quantity in Stock is less than
7
5
the Value
_
if
_
true is Order. Otherwise the Value
_
if
_
false is OK
.
Fill the formula down through all the rows.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!