Question: In cell E3, write an Excel function which can be copied down the column into cells E4:E7 to show the actual loan amount rounded to
In cell E3, write an Excel function which can be copied down the column into cells E4:E7 to show the actual loan amount rounded to nearest whole number or dollar. The loan amount is what you need to borrow from the bank after you have paid the specified down payment. Do not use a Financial Function. (Hint: multiply the selling price in column B by (1 minus the percent down in column D) and use the ROUND() function to round this to the nearest whole number. Remember to check if you need a $ in one or more of the numbers in the cells used since you are copying this down.). =ROUND(selling price * (1 - % down), round to the nearest whole number) =ROUND(________ * (1 - ________), 0)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
