7. Determine whether or not you will need a loan for each potential purchase.
a. In cell C15, enter a formula using an IF function to determine if you need a loan. Your available cash is
located on the Data sheet in cell A3. If the price of the car is less than or equal to your available cash,
display "no". If the price of the car is more than your available, cash, display "yes". Use absolute
references where appropriate—you will be copying this formula across the row.
b. Copy the formula to the appropriate cells for the other vehicles.
Solved by Z. Q. in 30 mins