Excel Formula for Multiplication

Excel formula for multiplication is also similar to the formula for addition. Only the sign of multiplication will be used. The Excel multiplication operator is *.

Let us look at the multiplication of two numbers 25 and 15. The entries will be made in row 60. Enter values as under:

            Cell A50: 25

            Cell B50: 15

The formula for multiplication is:

            =A50*B50

            Click on cell C50 to write the formula in that cell. Enter “=”. Click on cell with number 25 (reference: A50). Enter “*”. Click on cell with number 15 (reference: B50). Press Enter key. The answer is 375 in cell C50.

Previous

TOC

Next