Question: I ' m having trouble with the formula using index, match, and max. b 2 . What is the SKU with the highest gross margin?
Im having trouble with the formula using index, match, and max.
b What is the SKU with the highest gross margin? Hint: Use INDEX, MATCH and MAX formulas.
SKUDescriptionSales PriceCostGross MarginGross Margin DJIACDJI Action DJIOMDJI OM DJIAIRDJI AIR S DJIDSCDJI Action DualScreen Combo DJIPCDJI Action Power Combo DJIOMDJI OM SE DJIPODJI Pocket OSMPOsmo Pocket OSMAOsmo Action DJIFLPDJI OM Fill Light Phone Clamp DJIPDDJI Pocket DoItAll Handle DJIAIFDJI Air S Fly More Combo DJIMIDJI Mini MAVARMavic Air MAVIIMavic DJISMCDJI Smart Controller DJIFIDJI Air S ND Filters Set MAVAIMavic Air Intelligent Flight Battery DJIMINDJI Mini BagDJIFPVDJI FPV Combo DJIMMCDJI Motion Controller DJIFMKDJI FPV Fly More Kit DJIIFBDJI FPB Intelligent Flight Battery DJIGBADJI FPV Goggles Battery
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
