Excel Formula for Division

The formula for division is similar to that of multiplication with the difference that the division sign “/” will be used.

            Let us divide 240 by 15using Excel formula for division. Let us enter numbers in row 75 as follows:

            Cell A75: 240

            Cell B75: 15

            The formula for division will be written in cell C75 as under:

            =A75/B75

            The steps are as follows: Click the cell A75. Enter 240 in cell A75. Click cell B75. Enter 15. Click cell C75. Enter “=”. Click on cell with value 240 (reference: A75). Enter “/”. Click cell with number 15 (reference: B75). Press enter key. The answer 16 will be displayed in cell C75.

Previous

TOC

Next