Solved

# Excel - Product function versus using the asterisk *

Posted on 2012-08-20
342 Views
Is there any advantage to using the product function versus using the asterisk when multiplying numbers?
0
Question by:brothertruffle880

LVL 8

Accepted Solution

The function is the same, but you can use ranges in the Product function. So you can do =PRODUCT(A1:A5). It's kind of like SUM(). You COULD just use + too...
0

LVL 24

Assisted Solution

Product will ignore text
the asterix will return #Value if there is a text value
0

LVL 50

Assisted Solution

You can also get different results when blanks are involved, if A1 is blank and B1 contains 3 then

=A1*B1=0

=PRODUCT(A1,B1)=3

regards, barry
0

LVL 8

Expert Comment

Right. PRODUCT() multiplies all the non-blank values, like SUM().
0

## Featured Post

I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.