Explanation
PRODUCT multiplies multiple numbers or ranges.
Syntax
=PRODUCT(number1, number2, …)
Example
=PRODUCT(10,5,2)
Result: 100
Sales Example
|
Product |
Qty |
Price |
|
Keyboard |
5 |
800 |
|
Mouse |
10 |
500 |
For the first product:
=PRODUCT(B2,C2)
Result: ₹4,000
Alternative
=B2*C2
Both approaches can calculate the product of quantity and price.
Practice
Create a sales sheet with:
Product | Quantity | Price | Total
Calculate Total using PRODUCT.