How to Quickly Divide Numbers in Excel Cells Using Formula

Date:2019-10-10 Author:Cordelia

Division, like multiplication, is a common operation in mathematics. And in practical work, you also need to do division sometimes when processing data in Excel. To divide numbers quickly and correctly, the quickest way is undoubtedly using Excel formula. Here’s a simple guide.

1. Create a new column to output the calculation result.

How to Quickly Divide Numbers in Excel Cells Using Formula

2. Enter the formula =A2/B2 in C2. A2 and B2 refers to the cells of the dividend and divisor.

How to Quickly Divide Numbers in Excel Cells Using Formula

3. Press [Enter] or click anywhere outside the cell to work the formula out.

How to Quickly Divide Numbers in Excel Cells Using Formula

4. Use fill handle to copy this formula to all the selected cells below.

How to Quickly Divide Numbers in Excel Cells Using Formula

5. In this way you can batch divide the numbers in column A by column B in seconds.

How to Quickly Divide Numbers in Excel Cells Using Formula

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *