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
If want to multiply the values of A1,A2,A3,A4,A5,A6,A7 and A8 so according to earlier tutorials.
But now you can do it easily without to much writing like this
Above formula use when all values of consecutive cells.If multiply values of A1 to A4 and B4,D8 then write like this
Instead of write much like this
You also use nested PRODUCT formulas like this
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.
Want to store result in E1 then write above function in E1 like following fig.
Show result in F1 so write above expression in cell F1 as following.