Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Decisions Based On Data Analytics For Business Excellence

Authors: Bastian Weber

1st Edition

9358681683, 978-9358681680

Students also viewed these Databases questions

Question

Presentations Approaches to Conveying Information

Answered: 1 week ago