MULTIPLY

The MULTIPLY function in Google Sheets returns the product of two numbers. It is equivalent to using the * operator.

Function Syntax and Parameters

Syntax: MULTIPLY(factor1, factor2)

Parameters:

• factor1: The first number or range to multiply.
• factor2: The second number or range to multiply.

Step-by-Step Tutorial

To use the MULTIPLY function, follow these steps:

1. Using MULTIPLY with individual numbers:

   • Example: =MULTIPLY(3, 5)
   • Result: 15

2. Using MULTIPLY with ranges:

   • Example: If A1 has the value 2 and A2 has the value 3, then =MULTIPLY(A1:A2) will return 6.

Use Cases and Scenarios

You can use the MULTIPLY function in various scenarios, such as:

1. Calculating total cost: Multiply the quantity of an item by its price to find the total cost.
2. Calculating discounts: Multiply the original price of an item by the discount percentage to calculate the discounted price.
3. Projecting growth: Use the MULTIPLY function to forecast future values based on growth rates.

Related Functions

• DIVIDE: Divide one number by another.
• SUM: Add numbers together.

Please note that this function does not have a related video example or related articles.