Question: Insert a lookup function in cell C5 to display the basic annual membership cost for the first client. Use the reference table in A18:C20. 10


Insert a lookup function in cell C5 to display the basic annual membership cost for the first client. Use the reference table in A18:C20. 10 Insert a function in cell B2 to display today's date. Use an IF function in cell E5 to calculate the annual total amount, which is the sum of the basic cost and locker fees (in B22) for those who rent a locker. For people who do not rent a locker, the annual cost is only the cost shown in column C. The Locker column displays Yes for clients who rent a locker and No 10 for those who don't
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
