INSTRUCTIONS:
Use an Excel formula to check if C2 cell is a 'FHA' Loan.
Then execute the following steps:
In cell E3 - If the 'Type of Loan' = FHA, multiply the value in C4 by 0.0175, if not return 0.
In cell E4 - If the 'Type of Loan' = FHA, multiply the value in C4 by 1.0175, if it is not an FHA Loan, then return the value in C4.
In cell E5 - If the 'Type of Loan' = FHA, multiply the value in C3 by .78, if not return 0.
Solved by Z. Q. in 22 mins