This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 12. Use the IF function to determine YES or NO as to whether or not you can afford the payment amount you calculated in C7:F7. If the payment amount is less than $800, YES should appear, if not NO should appear. 13. In C11:C22, calculate the % of the Total Loans for each month. (Hint: To calculate the % of Total Loans, divide the loan amount for the month by the total loans. For example, for January: B11/B23. Remember to use an absolute cell reference for B23.) 14. In D11:D22, use the IF function to perform the following calculation for each month. If the loan amount is greater than $100,000.00 then you should multiply the loan amount * 2%. If the loan amount if not greater than $100,000.00 then nothing should appear in the cell. 15. Align text appropriately, apply shading, apply borders, merge and center text as noted above....
View Full Document
- Fall '09
- $800, $100,000.00, total loans