Answered step by step
Verified Expert Solution
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
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 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 21Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started