How To Excel Multiply?

Use the formula `=A1*B1`

Use the multiplication operator `*`

Multiply multiple cells with `=A1*B1*C1`

Multiply by a constant with `=A1*10`

Use absolute references like `=$A$1*B1`

Copy the formula down or across with fill handle

Use `=PRODUCT(A1:A5)` to multiply a range

Use `=PRODUCT(A1:A5,B1:B5)` to multiply multiple ranges

Use `Paste Special` > `Multiply` to multiply values by a number

Use `AutoSum` dropdown if needed for quick access to `PRODUCT` functions

Suggested for You

Trending Today