In cell E22, use the IF function to determine if you can afford a 20-year loan of $240,000. If the payment for a 20year loan of $240,000 is less than the maximum affordable amount in cell E3, then you can afford it; otherwise you cannot afford it. Copy this formula to cell E23 to determine if a Eyear loan of $250,011!) is affordable