ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   invoice templates (https://www.excelbanter.com/new-users-excel/216029-invoice-templates.html)

Carl Gerace

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

Shane Devenshire[_2_]

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



All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com