Use Product Function In Excel

In this tutorial we will learn how to use product function in excel. In earlier tutorials you learn how to multiply values of two cells in excel. For multiplication earlier use

=First cell reference* Second cell reference

Like =A1*B1

If want to multiply the values of A1,A2,A3,A4,A5,A6,A7 and A8 so according to earlier tutorials.

=A1*A2*A3*A4*A5*A6*A7*A8

But now you can do it easily without to much writing like this

=PRODUCT(A1:A8)

Above formula use when all values of consecutive cells.If multiply values of A1 to A4 and B4,D8 then write like this

=PRODUCT(A1:A4,B4,D8)

Instead of write much like this

=A1*A2*A3*A4*B4*D8

You also use nested PRODUCT formulas like this

=PRODUCT(PRODUCT(A1:A4),PRODUCT(B4,D8))

use product function in excel example:-

Open work book of microsoft excel and insert some values which you want to multiply like as following fig.

You want to multiply values of A1,A2,A3 and A4. Show result in C1 write formula in C1. So use formula like this

=PRODUCT(A1:A4)

After press enter formula applied on cells and result show in C1 like below.

Without using formula you done like this =A1*A2*A3*A4 and result in D1.

After pressing enter multiplication done and result show in D1. You can see that results in C1 and D1 are same.

If you want to multiply values of consecutive and non consecutive cells so you done it by following expression.

=PRODUCT(A1:A8,B1,D1)

Want to store result in E1 then write above function in E1 like following fig.

After pressing enter multiplication done and result in E1 cell.

Multiplication by nested product function is performed like this expression.

=PRODUCT(PRODUCT(A1:A8),PRODUCT(B1,D1))

Show result in F1 so write above expression in cell F1 as following.

After pressing enter result show in F1 and you observe that both results of E1 and F1 are same like following fig.

So in this tutorial you had learned how to use product function in excel and also learn how to use nested functions in Microsoft Excel.