I need to input a formula in cell B12to compute the loan amount by subtracting the down payment from the purchase price. The formula will need to be an =IF function since the down payment can be stated as either a dollar amount or percentage. If the down payment is a percentage, you will need to convert that percentage into a dollar amount
Solved by I. L. in 26 mins