So im having a hard time understanding how to use Microsoft excel and its functions. The assingment im currently working says:

In the Credit Balances worksheet, manually enter a formula that will calculate the balance of credit card 1 (CC 1) in row 7.

d. Then, enter a similar equation for credit card 2 (CC 2) in row 7. A significant difference between the two equations is the addition of a check for CC 1s balance. If the balance for the respective month is less than zero for the CC 1 balance, then the CC 2 balance equation should subtract the snowball payment amount (cell C3). For example, if the CC 2 balance is being displayed in cell C27, then it should be checking for CC 1s balance is cell B27. Once you have entered this equation in cell C7, autofill it down until the CC 2 balance is less than or equal to zero. Finally, enter a similar equation for credit card 3 (CC 3) in cell D7. Here too, you will be checking for a less than zero balance but instead of checking CC 1, you will be checking the CC 2 balance and adding both the payments for CC 1 and CC 2 to the CC 3 payment. Once you have entered this equation is cell D7, autofill it down until the balance is less than zero. With all the equations entered and autofilled, you need to then autofill the date (column A) down to where the CC 3 balance falls below zero. Then, enter a SUM function in cell F6 and autofill that down to where the CC 3 balance falls below zero.

For Credit card one, I had finished in class and had it looked over so it was done correctly, I just don't know how to transition that over with the snow ball payments. So for B7 the function is " =IF(B6-$B$2+(B6*$B$1/12)

Home Insert Page Layout Formulas Data Review View -apple-syst... 12 A A General Paste AND 1 Interest Rate 2 Payment 3 Snowball Payment 4 5 Date 8.99% $150.00 n/a 8.99% $250.00 $150.00 10.99% $395.00 CC 2 $11,968.00 CC 3 $24,100.00 CC 1 $6,898.00 $6,799.68 $6,700.62 $6,600.82 $6,500.27 $6,398.97 $6,296.91 $6,194.08 $6,090.48 $5,986.11 $5,880.96 $5,775.02 $5,668.28 $5,560.74 $5,452.40 $5,343.25 $5,233.28 $5,122.49 $5,010.86 $4,898.40 $4,785.10 $4,670.95 Total Debt 8 10 12 13 14 15 16 17 18 19 20 21 23 24 25 26 27 Logical Functions Payments Credit Balances Tornado Chart + Edit