In cell B10, enter a formula using the IF function to display Buy it! if the monthly payment for the truck loan in cell B5 is less than the value in cell B9. Display Pass if it is not. Use cell references.

B $ 60,000.00 24 5% A 1 Price 2 Loan term (in months 3 Interest (annual) 4 5 Monthly payment 6 Total payments 7 Interest paid 8 9 Average sales 10 Buy new truck? 11 $ 2,632.28 $ 63,174.80 $ 3,174.80 $ 4,500.00 12 13