In this example you will need a nested IF. For down payments of 5%or less the rate is 3% of the financed amount, for a down payment of less than 20% the rate is2.5%, for down payments of 20% or more a...