| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage Discount Total | Excel Discussion (Misc queries) | |||
| Percentage Discount Total | Excel Discussion (Misc queries) | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
| formula for - price times discount times tax = final price | New Users to Excel | |||
| create a function for Discount if qty > 50 then take 5% off total | Excel Worksheet Functions | |||
Hybrid Mode
