Topic 1, Clothing Orders

Topic 1, Clothing Orders

Case Study

Exhibit.

CORRECT TEXT

On the ‘’Prices’’ worksheet, in the ‘’inventory Notice’’ column, use a function to display ‘’Low’’ if the ‘’ inventory Level % is below 15%. Otherwise, leave the ‘’Inventory Notice’’ blank.

View Answer

Answer: =IF(inventory level<15%), "low", ""). Select and drag to apply to other rows