invoice templates

C

Carl Gerace

All of the templates out there does anyone know of a template that will
caculate a percentage discount off of a service or product?
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have a document with 8 different templates on it. 1
Password protect new workbooks from template 0
Language of the templates 0
Invoice template for client... excel, access or accounting software... 1
Incorporating the User Profile location into a document template path 1
Template location changes from user to user 0
MS Project - error message when checking "Critical tasks" 1
Sorting personal templates alphabetically in Office 365 for mac OS? 3

Top