Question: In SKU Classification, instead of using the VLookup function ( the formulas in column I ) , we can use the If function to get

In SKU Classification, instead of using the VLookup function (the formulas in column I),
we can use the If function to get the same result. Research how to use this function in
Excel help (Pressing F1 in Excel will bring up the help window). Make a copy of the
worksheet Database. In the copied worksheet, remove the Vlookup functions in
column I, and classify SKUs again by using IF Function. Hint: the formula in Cell I6
should be =IF(H6<=0.8,"A",IF(H6<=0.95,"B","C")). Compared with the VLookup
statement, is the nested If statement a more flexible way or not? Why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!