C Carl Gerace Jan 10, 2009 #1 All of the templates out there does anyone know of a template that will caculate a percentage discount off of a service or product?
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 Jan 10, 2009 #2 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.
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.