I need help with the formulas with this excel worksheet.

payment to display as a negative number.

In cell B$10,$ enter a formula to display the current date $($just the date, not the date

and time$).$

Enter a formula in cell B$16$ to estimate the date of the last loan payment. Take the

number of years to pay $($cell B$7)$ times $365\mathrm{.}3$ and add that to the date of the first

loan payment $($cell B$15).$

Enter a formula in cell B$17$ to estimate the number of days until the loan is $p$

Complete the Summary sheet information.

On the Summary sheet, in cell B$5,$ enter a simple formula to reference the

Cumulative GPA number from the GPA worksheet $($GPA worksheet, cell B$5).$

Do the same for Total Units $($cell B$6),$ Total Cost $($cell B$9),$ and Total Debt $($cell B$3).$ For

Total Debt, reference the Amount Owed number from the Loan sheet.

Compute the Average Cost Per Unit by dividing the Total Cost $($cell B$8)$ by the Total

Units $($cell B$6).$

Compute Average Debt Per Unit in the same way.

In cell B$14,$ enter a formula using a statistical function to calculate the most paid for

any semester. Reference cells B$17$ and B$23$ in the GPA sheet. Hint: You will need two

arguments.

In cell B$16,$ enter a formula to calculate the average semester cost. Reference cells

B$17$ and B$23$ in the GPA sheet. Hint: You will need two arguments.

In cell F$1,$ enter a formula using the IF function to determine if the student met her

GPA goal. Display "yes" if the goal was met and $"$no$"$ if it was not.

In cell F$2,$ enter a formula using the IF function to determine if the student met her

unit goal. Display "yes" if the goal was met and $"$no$"$ if it was not.

Before finishing the project, check each worksheet for errors.

Save and close the workbook.