Please show your excel formulas/functions

On the left in the checkbook register. On the right is the bank statement. In the Reconcile column for the bank statement and the checkbook register, add an "X" if the amount is both in the bank statement and the checkbook register. Using whichever method you would like calculate the Adjusted Bank Balance somewhere in the worksheet. Using whichever method you would like calculate the Adjusted Checkbook Balance somewhere in the worksheet. You do not need to add any of the new items from the Bank Statement to the checkbook register. Your goal is to simple calculate the two adjusted balances. Date Ref # Withdraw Deposit Reconcile? Check Book Register Description Balance Forward ==>> Withdraw (already reconciled from last month) Sherman Williams Finland Birch International Collections from Boomerang Customers 59 PG&E Collections from Boomerang Customers 60 Isaac's Compressor Shop $120.00 $589.00 $1,225.15 1/31/2020 AMT22109 2/3/2020 Check #2591 2/6/2020 Check #2592 2/7/2020 Deposit 2/19/2020 01453339 2/28/2020 Deposit 2/28/2020 Check #2593 Balance $2,589.22 $2,469.22 $1,880.22 $655.07 $1,642.28 $1,343.55 $2,863.33 $2,793.90 Bank Statement Date Ref # Withdraw Deposit Reconcile? Balance Balance Forward ==>> $2,469.22 2/3/2020 Check #2591 $589.00 $1,880.22 2/6/2020 Check #2592 $1,225.15 $655.07 2/7/2020 Deposit $987.21 $1,642.28 2/19/2020 01453339 $298.73 $1,343.55 2/27/2020 78912-Deposit-GR $2,519.92 $3,863.47 2/28/202019002-Deposit-FR $544.25 $4,407.72 2/28/2020 Refund from IN 342 $5.15 $4,412.87 2/28/2020 est $1. $4,413.99 2/28/2020 Service Fee $0.55 $4,413.44 $987.21 N. $298.73 $1,519.78 $69.43