The spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyers Agent, Dual Agent, Sellers Agent). You want to switch the codes for the actual descriptions. In cell E12 of the Details sheet, insert the SWITCH function to evaluate the agent code in cell D12. Include mixed cell references to the codes and roles in the range J2:K4 for the values and results arguments. Copy the function to the range E13:E39.

Carey 1 Loan (PV) 2 APR 3 Monthly Rate 4 NPER 5 Monthly Payment $ 300,000.00 4.50% 0.38% 360 $1,520.06 SA 7 Payment Number W K Average Sold Total Sold Highest Sold Price Number Sold Dual Agent Total # Sold Prices Price Agent Codes and Commissior 2 $ 601,386 7 3 $ 1,343,000 $ 643,000 BA Buyer's Agent 3 $ 385,794 9 Hernandez 5 $ 2,385,000 $ 595,000 DA Dual Agency 4 $ 640,958 6 Pijuan 5 $ 2,871,800 $ 725,900 Seller's Agent 5 $ 334,667 6 sion by Agent Input for Bonus 7 $ 204,922 Percent of List 8 $ 155,348 Days on Market 9 $ 215,046 Bonus Amount $ 10 City 11 Selling Agent Agent Type Agent Type List Price Sold Price Days on Listing Date Sale Date Agent Market Commission 12 Cedar Hills Pijuan DA Dual Agency $ 725,000 $ 705,000 4/1/2021 6/16/2021 76 $ 38,775.00 $ 13 Lehi Pijuan DA Dual Agency $ 350,799 $ 350,000 4/1/2021 5/25/2021 54 $ 19,250.00 $ 14 American Fork Pijuan DA Dual Agency $ 385,900 $ 385,900 4/1/2021 4/30/2021 29 $ 21,224.50 $ 15 Alpine Carey SA Seller's agent $ 500,000 $ 495,800 4/3/2021 6/10/2021 68 $ 16,113.50 $ 16 Lehi Pijuan BA Buyer's Agent $ 345,999 $ 345,000 4/3/2021 6/1/2021 59 $ 9,487.50 $ 17 American Fork Hernandez DA Dual Agency $ 325,000 $ 320,000 4/12/2021 5/30/2021 48 $ 17,600.00 $ 18 Alpine Pijuan Dual Agency $ 750,250 $ 725,900 4/12/2021 11/1/2021 203 $ 39,924.50 $ 19 Alpine Carey DA Dual Agency $ 645,000 $ 643,000 4/18/2021 6/23/2021 66 $ 35,365.00 $ 20 American Fork Pijuan Buyer's Agent $ 425,000 $ 415,000 4/18/2021 6/30/2021 73 $ 11,412.50 $ 21 Lehi Pijuan Seller's Agent $ 325,000 $ 330,000 4/28/2021 6/1/2021 34 $ 10,725.00 $ 22 American Fork Pijuan Seller's agent $ 425,815 $ 418,000 4/28/2021 9/15/2021 140 $ 13,585.00 $ 23 Alpine Pijuan DA Dual Agency $ 700,000 $ 705,000 4/30/2021 6/19/2021 50 $ 38,775.00 $ 24 Lehi Hernandez SA Seller's Agent $ 365,000 $ 363,000 5/1/2021 6/18/2021 48 $ 11,797.50 $ 25 Cedar Hills Carey SA Seller's Agent $ 885,500 $ 800,000 5/1/2021 6/6/2021 36 $ 26,000.00 $ 26 Cedar Hills Seller's Agent $ 610,000 $ 600,000 5/1/2021 6/26/2021 56 $ 19,500.00 $ 27 Cedar Hills Hernandez DA Dual Agency $ 560,700 $ 565,000 5/1/2021 5/30/2021 29 $ 31,075.00 $ Details Map Loan Beg Balance Interest $300,000.00 $1,125.00 $299,604.94 $1,123.52 $299,208.41 $1,122.03 $ 298,810.38 $1,120.54 $ 298,410.87 $1,119.04 $ 298,009.85 $1,117.54 $ 297,607.33 $1,116.03 $ 297,203.30 $1,114.51 $ 296,797.76 $1,112.99 $296,390.69 $1,111.47 $295,982.10 $1,109.93 $295,571.98 $1,108.39 Principal $395.06 $396.54 $398.02 $399.52 $401.02 $402.52 $404.03 $405.54 $407.06 $408.59 $410.12 $411.66 600 DA 21 Cumulative Totals after Year 1 22 Interest $ 13,400.99 23 Principal Paid $ 4,839.68 SA SA 25 What if the goal is $1,400 monthly payment? 26 Monthly Payment $ 1,400.00 27 Monthly Rate Needed 0.32% 28 APR Needed 3.81% 29 Details 1... + Carey SA D . Carey 1 Loan (PV) 2 APR 3 Monthly Rate 4 NPER 5 Monthly Payment $ 300,000.00 4.50% 0.38% 360 $1,520.06 SA 7 Payment Number W K Average Sold Total Sold Highest Sold Price Number Sold Dual Agent Total # Sold Prices Price Agent Codes and Commissior 2 $ 601,386 7 3 $ 1,343,000 $ 643,000 BA Buyer's Agent 3 $ 385,794 9 Hernandez 5 $ 2,385,000 $ 595,000 DA Dual Agency 4 $ 640,958 6 Pijuan 5 $ 2,871,800 $ 725,900 Seller's Agent 5 $ 334,667 6 sion by Agent Input for Bonus 7 $ 204,922 Percent of List 8 $ 155,348 Days on Market 9 $ 215,046 Bonus Amount $ 10 City 11 Selling Agent Agent Type Agent Type List Price Sold Price Days on Listing Date Sale Date Agent Market Commission 12 Cedar Hills Pijuan DA Dual Agency $ 725,000 $ 705,000 4/1/2021 6/16/2021 76 $ 38,775.00 $ 13 Lehi Pijuan DA Dual Agency $ 350,799 $ 350,000 4/1/2021 5/25/2021 54 $ 19,250.00 $ 14 American Fork Pijuan DA Dual Agency $ 385,900 $ 385,900 4/1/2021 4/30/2021 29 $ 21,224.50 $ 15 Alpine Carey SA Seller's agent $ 500,000 $ 495,800 4/3/2021 6/10/2021 68 $ 16,113.50 $ 16 Lehi Pijuan BA Buyer's Agent $ 345,999 $ 345,000 4/3/2021 6/1/2021 59 $ 9,487.50 $ 17 American Fork Hernandez DA Dual Agency $ 325,000 $ 320,000 4/12/2021 5/30/2021 48 $ 17,600.00 $ 18 Alpine Pijuan Dual Agency $ 750,250 $ 725,900 4/12/2021 11/1/2021 203 $ 39,924.50 $ 19 Alpine Carey DA Dual Agency $ 645,000 $ 643,000 4/18/2021 6/23/2021 66 $ 35,365.00 $ 20 American Fork Pijuan Buyer's Agent $ 425,000 $ 415,000 4/18/2021 6/30/2021 73 $ 11,412.50 $ 21 Lehi Pijuan Seller's Agent $ 325,000 $ 330,000 4/28/2021 6/1/2021 34 $ 10,725.00 $ 22 American Fork Pijuan Seller's agent $ 425,815 $ 418,000 4/28/2021 9/15/2021 140 $ 13,585.00 $ 23 Alpine Pijuan DA Dual Agency $ 700,000 $ 705,000 4/30/2021 6/19/2021 50 $ 38,775.00 $ 24 Lehi Hernandez SA Seller's Agent $ 365,000 $ 363,000 5/1/2021 6/18/2021 48 $ 11,797.50 $ 25 Cedar Hills Carey SA Seller's Agent $ 885,500 $ 800,000 5/1/2021 6/6/2021 36 $ 26,000.00 $ 26 Cedar Hills Seller's Agent $ 610,000 $ 600,000 5/1/2021 6/26/2021 56 $ 19,500.00 $ 27 Cedar Hills Hernandez DA Dual Agency $ 560,700 $ 565,000 5/1/2021 5/30/2021 29 $ 31,075.00 $ Details Map Loan Beg Balance Interest $300,000.00 $1,125.00 $299,604.94 $1,123.52 $299,208.41 $1,122.03 $ 298,810.38 $1,120.54 $ 298,410.87 $1,119.04 $ 298,009.85 $1,117.54 $ 297,607.33 $1,116.03 $ 297,203.30 $1,114.51 $ 296,797.76 $1,112.99 $296,390.69 $1,111.47 $295,982.10 $1,109.93 $295,571.98 $1,108.39 Principal $395.06 $396.54 $398.02 $399.52 $401.02 $402.52 $404.03 $405.54 $407.06 $408.59 $410.12 $411.66 600 DA 21 Cumulative Totals after Year 1 22 Interest $ 13,400.99 23 Principal Paid $ 4,839.68 SA SA 25 What if the goal is $1,400 monthly payment? 26 Monthly Payment $ 1,400.00 27 Monthly Rate Needed 0.32% 28 APR Needed 3.81% 29 Details 1... + Carey SA D