Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Divide Numbers in Excel 2013

In this video you’ll learn how to divide numbers in Excel.

If you only want to divide a couple of numbers, simply enter the numbers directly into a new cell after an equals sign and using the forward slash (/) as the sign for division: =2*2.

If you want to write a formula that you can copy and apply to other sets of numbers, the easiest way to do so is by noting the cell references of the numbers you want to add and applying this simple formula: “=A1/A2”.

You can also use your mouse to select cells that contain numbers that you want to divide.

If you have a large amount of numbers to divide, the quickest way is to type a range of cells separated with a colon (:) to divide all the numbers contained in the range you specified.