You are viewing a single comment's thread from:

RE: The CHOOSE function in Excel

in #excel6 years ago

Formula used to return Selling Price: CHOOSE(B13,B2,B3,B4)
Formula used to return Units Sold: (CHOOSE(B14,B7,B8,B9)
Formula used to return Selling Price: (CHOOSE(B13,B2,B3,B4))*(CHOOSE(B14,B7,B8,B9))