Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Excel - Product function versus using the asterisk *

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

LVL 8

Accepted Solution

d0ughb0y earned 668 total points
ID: 38313496
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

Steve earned 668 total points
ID: 38313520
Product will ignore text
the asterix will return #Value if there is a text value
0

LVL 50

Assisted Solution

barry houdini earned 664 total points
ID: 38313985
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

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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
###### Suggested Courses
Course of the Month21 days, 6 hours left to enroll