| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
invoice templates
All of the templates out there does anyone know of a template that will
caculate a percentage discount off of a service or product? -- Carl Gerace |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
invoice templates
Hi,
Do you really need a template? Suppose Cost is in A1:A100 Enter your discount percentage in D1 In B1 enter the formula =A1*D$1 Copy this down. This calculates the discount amount, or =A1*(1-D$1) calculates the price after discount. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Carl Gerace" wrote: All of the templates out there does anyone know of a template that will caculate a percentage discount off of a service or product? -- Carl Gerace |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| invoice toolbar for invoice calcuation and assign number | Excel Discussion (Misc queries) | |||
| sales invoice templates | Excel Worksheet Functions | |||
| Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
| Invoice Templates in Excel | Excel Discussion (Misc queries) | |||
| Invoice templates | New Users to Excel | |||
Linear Mode
