Subtract a discount from total price?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can not figure out how to offer a discount on my invoice worksheet. I need
the discount to come before the sales tax
 
If:


A1 is total price
B1 is discount (formatted as %)
C1: =A1*(1-B1) will give discounted price

A1=$1000
B1=15%
C1=$850

HTH
 
Not knowing what you sheet looks like
Lets say ColumnA has Item ColumnB has Ratail ColumnC has Discount
ColumnD has Tax and Column E has TotalAmount
you could use this Discount entered in has positive number
=B2-C2+D2
use this Discount entered in has negative number
=B2+C2+D2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a formula for price * discount* tax =final price 6
Percentage when total sales is a credit 2
How To Create a Percentage Discount in Invoice 5
NEGATIVE PERCENT FORMULA 3
How do I find the original price? 4
Calculating discount uptake 1
Discount to Client 1
Percentage Discount 3

Back
Top