Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

really confused.. please include any formulas or steps involved A B D E F G H 1 J K L M N o Q R

image text in transcribedreally confused.. please include any formulas or steps involved

A B D E F G H 1 J K L M N o Q R S Quantity in Stock Reorder Level? Quantit Inventory Reorder Order Item y in ID Level needed? 1 Stock 2 1094 TIAB sampler 18 5 3 1095 SPF 15 gel 18 8 4 1096 SPF 30 gel 16 8 5 1097 SPF 45 gel 22 8 6 1098 SPF 60 gel 12 8 7 1099 Yan Can Shampoo 2 5 8 1100 Yan Can Conditioner 28 5 9 1101 Yan Can Hair Mask 4 5 10 1102 Yan Can Mousse 2 5 11 1103 Yan Can Gel 1 5 12 1104 Yan Can Moulding Gel 12 5 13 1105 Yan Can Masque 6 5 14 15 Many formulas can be found under FORMULAS tab, in the Function Library. They are categorized. 16 The IF function is considered a LOGICAL function. YES NO 17 18 19 C2) is greater than the reorder level (cell D2) and "yes" if it is not. Copy (or drag) the formula to E13. 20 21

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_2

Step: 3

blur-text-image_3

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

Focus On Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes

2nd Edition

0073530638, 9780073530635

More Books

Students also viewed these Finance questions