How to Use the PRODUCT function to multiply values in Excel

Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

Normally values in a worksheet are multiplied with the * operator in formulas like =A1*B1. However, Excel also provides a useful function to do the same calculation. Use the PRODUCT function to multiply all the given numbers and return the product. Here is the syntax tha is used:
PRODUCT(number1, number2, …)
number1, number2, …: From 1 to 30 numbers to be multiplied. As an example, calculate a price reduction with the PRODUCT function using a standard factor in cell D1.
To calculate the price reduction:

In cells A2:A10 list some prices.
Enter in cell D1 the value 0.15 to calculate a 15% price reduction.
Select cells B2:B10 and type the following formula: =PRODUCT(A2,$D$1).
Press Ctrl+Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

Article Information

1 Comments

Jon Peltier

1

What makes PRODUCT any better than the * operator? It takes longer to type, it’s less intuitive, and it’s less easy to read.
October 21st, 2008 at 10:36 pm