| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what template will figure out a %discount off an item price
I need a sales invoice template that will calculate a percent discount off
the item price. So I want it to have a field for quantity, price, %discount, then total. All of the ones that I've seen which show discount are for a discount that I have to calculate and enter myself. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
what template will figure out a %discount off an item price
Toatal = price - (price-%age discount)
=100-(100*.1) = 90 =B1-(B1*C1) Gord Dibben MS Excel MVP On Sat, 28 Mar 2009 09:30:01 -0700, knitsteel wrote: I need a sales invoice template that will calculate a percent discount off the item price. So I want it to have a field for quantity, price, %discount, then total. All of the ones that I've seen which show discount are for a discount that I have to calculate and enter myself. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract a discount from total price? | Excel Discussion (Misc queries) | |||
| Most recent price per item | Excel Worksheet Functions | |||
| I am trying to figure a discount based on a count | 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 | |||
Linear Mode
