Answered step by step
Verified Expert Solution
Question
1 Approved Answer
what is the formula to put in??? 16. Andre wants to include a quick way to determine the level of the membership, which is based
what is the formula to put in???
16. Andre wants to include a quick way to determine the level of the membership, which is based on the Amount values. Enter a formula using the HLOOKUP function as follows: a. In cell C3, enter a formula using the HLOOKUP function. b. Use a structured reference to the Amount column ([Amount]) as the lookup value. c. Look up that value in the table array shown in the range G2:J3, using an absolute reference to that range. d. Return the value in row 2 of the table array. Use TRUE as the range_lookup parameter, so that the formula will find the closest approximate value (as the level covers a range of membership amounts.) f. Fill the formula into the range C4:C55, if necessary. g. Clear the contents of cell C56 in the Total row. 16. Andre wants to include a quick way to determine the level of the membership, which is based on the Amount values. Enter a formula using the HLOOKUP function as follows: a. In cell C3, enter a formula using the HLOOKUP function. b. Use a structured reference to the Amount column ([Amount]) as the lookup value. c. Look up that value in the table array shown in the range G2:J3, using an absolute reference to that range. d. Return the value in row 2 of the table array. Use TRUE as the range_lookup parameter, so that the formula will find the closest approximate value (as the level covers a range of membership amounts.) f. Fill the formula into the range C4:C55, if necessary. g. Clear the contents of cell C56 in the Total row Step 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