Discount percentage on quote template

[chrissyl725]

Hi

I have a quote template which displays the unit price, discount and total payable. What I need is to be able to enter the discount (in percentage format) being offered on the unit price and then have that percentage discount automatically calculate in the Total Payable cell. The discounts can vary, so the formula will need to allow for changing unit prices and discounts. The cells being used are E17(Unit Price), F17(Discount) and G17(Line Total).

If anyone can help it would be much appreciated.

[Richard Buttrey]

Hi,

Presumably

=E17*(1-F17)

[chrissyl725]

Thanks for that Richard - I should have added that the Line Total formula will also need to include quantites which are entered into cell A17. I also use an IFERROR function "" in my formulas so that if nothing is entered on the template the cells remain blank.

[Richard Buttrey]

If you mean you want quantity and value in the same G17 cell then something like

="Qty: "&A17&" Total "&E17*(1-F17)

Add a conditional IF test if you want to show blank when either Quantity, Value or % cells are blank

[chrissyl725]

Thank you Richard the formula works well. I would just like the calculated $ total to show in cell G17 though, not the quantity or the words Qty or Total.

[Richard Buttrey]

Somewhat confused since your previous post seemed to be asking for the quantity to be incorporated when you said.

the Line Total formula will also need to include quantites which are entered into cell A17.

Regards

[chrissyl725]

That's ok, Richard. I realise that the request I put in was not clear enough. I have actually worked it out though based on the suggestion you provided. Thank you for your help on this.