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.

work sheet to use product function in excelYou 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)

formula for product in excelAfter press enter formula applied on cells and result show in C1 like below.

result of product function in excelWithout using formula you done like this =A1*A2*A3*A4 and result in D1.

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

multiplication result of D1 in excel
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.

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

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

Please follow and like us:

ali hiader

Leave a Reply

Your email address will not be published. Required fields are marked *