I apologize in advance if this has been answered. I searched and couldn't find my exact issue. I am creating a quote tool that lists items with a column for cost, sell, and profit. Those columns are totaled. Then I have an area for lease info where the total in the "sell" column is multiplied by the lease rate to give us the payment. We have the ability to markup or down based on prospects needs and want the payment to reflect the markup or down % that is chosen. Here is a link to the workbook. F28 needs to be equal to J17 plus the Mark Up/Down % chosen, multiplied by the lease rate. I have the range for Mark Up/Down hidden in column N (-100 to 100).
So basically I need a payment to be calculated that takes the "sell" total, adds a chosen discount or markup %, and multiplies that new amount by the lease rate. Here is a link to a screen grab that may help.
So basically I need a payment to be calculated that takes the "sell" total, adds a chosen discount or markup %, and multiplies that new amount by the lease rate. Here is a link to a screen grab that may help.