We have a problem that is probably easily solved, but we just don't know how to write the formula. We would like to be able to give a percentage discount to our customers and as you see in the attachment of our price quotes we have the column for it, but we don't know how to work it or set up the formula.
We would like to be able to say
1 x bartender is 4500 with a 15% discount, Total price is 3825
Thanks, from Adam. Feel free to change the format of our invoice to make it work, but we do need to keep it to 1 A4 page.