Since the IFS function is new to Excel, it is important that you understand how to solve problems nesting IF functions together, as many organizations may not have the most up to date version of the software. On the Inventory worksheet, enter a nested IF formula into cell L2 to determine the reorder status based on the following. • A blank should be returned if the current inventory and reorder point are both blank. • Rush should be returned if the Discontinue value is N and current inventory is less than or equal to the rush reorder point. • Reorder should be returned if the Discontinue value is equal to N and current inventory is less than the reorder point. • For all others, OK should be returned. • Fill the formula down through cell L21.
Added by Vicente R.
Close
Step 1
For the example below I will assume: - Discontinue is in H2 - Current Inventory is in I2 - Reorder Point is in J2 - Rush Reorder Point is in K2 - You will enter the status formula in L2 If your worksheet uses different columns, replace H2/I2/J2/K2 with the correct Show more…
Show all steps
Your feedback will help us improve your experience
Supreeta N and 71 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Jayden puts plants on sale if they have been in inventory for 40 days or more and the store is not reordering more plants of that type. In column J, Jayden wants to display whether to put a type of plant on sale based on these criteria.In cell J5, insert a formula using the AND function that returns TRUE if the reordering indicator (cell I5) is equal to "N" and if the days in inventory (cell H5) is greater than 40. Use the Fill Handle to fill the range J6:J15 with the formula in cell J5, filling the range without formatting.
Brooke B.
Text: Question -2 [15 marks] Use of Formulas - Product, If, Counta, Countif, Sumif SRNO ITEMS QTY RATE AMOUNT GRADE 1 AC 20 40000 ? ? 2 FRIDGE 30 20000 ? ? 3 COOLER 15 10000 ? ? 4 WASHING MACHINE 14 15000 ? ? 5 TV 18 20000 ? ? 6 FAN 17 2000 ? ? 7 COMPUTER 10 25000 ? ? 8 KEYBOARD 5 250 ? ? 9 MOUSE 25 100 ? ? 10 PRINTER 30 12000 ? ? Q.1 Using of Product Formula to Calculate Amount = Qty*Rate [Answer in column E] Q.2 How Many Items in a List? Items in a list >> Q.3 How Many Items with qty Greater Than > 20 and Less Than <20? qty > 20 qty <20 Q.4 Calculate Item Computer Qty, Rate, and Amount using Sumif Formula Qty >> Rate >> Amount>> Q.5 If Items Amount is Greater > 500000, Then Items are "Expensive"; otherwise, "Let's Buy it". [Answer in column F]
Madhur L.
Make the following calculations in each of the two worksheets without grouping the sheets: • In cell B4, enter a function to sum the Quantity in Stock data and then apply Comma Style with zero decimal places to the result. • In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format.
Akash M.
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
Watch the video solution with this free unlock.
EMAIL
PASSWORD