Subtract a discount from total price?
 

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

Subtract a discount from total price?
 

a 15% discount yu multiply by .85 (1-.15).
=A1*.85



"smchevy95" wrote:

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

Subtract a discount from total price?
 

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

"smchevy95" wrote:

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

Subtract a discount from total price?
 

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


"smchevy95" wrote:

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