Basic mathematical functions are a fundamental part of Excel. They’re key to data analysis, but dividing isn’t as simple as some of the other functions. You have to know how to work around the lack of a function, so here are some tips on how to divide in Excel.
We’ll walk through a few of the basic methods as well as what to avoid so that you don’t get a dreaded #DIV/0! error.
How to divide in Excel
Using basic formulas
The very easiest way to divide in Excel is by using a formula within a single cell. This is just like entering a formula on a calculator, and in our example, we have =40/5. Once we hit Enter, you’ll see the answer displayed as 8.
Odds are, you won’t be using Excel to divide within a single square that often, so let’s talk about dividing cells.
Because there is no division function, you’ll have to get used to writing out the formula. If you want to divide one cell by another, you’ll get a formula that looks like this: =A1/B1. Press Enter to get your result.
Excel displays a #DIV/0! error when you try to divide by zero or you divide by an empty cell. The easiest way to remedy the situation is to double-check the cells that you use before you press Enter.
Using QUOTIENT and MOD functions
While there are not standard division functions, there are still two functions that you should know to find integers and remainders from division.
Use the QUOTIENT function to return the integer result of your division. This will discard the remainder in case you are looking for data that requires whole numbers.
To use the QUOTIENT function, start with the =QUOTIENT( section of the formula. Then you can fill in the two cells that you need. In our example, we have =QUOTIENT(A1, B1).
Whereas the QUOTIENT function returns the integer result, the MOD function returns the remainder.
To use the MOD function, enter =MOD( in the formula bar. Fill in the cells we used above, A1 and B1. Then hit enter. Between the two functions, our result is that the integer is 8 and the remainder is 3.
If you needed to find the number of tables you need for an event, the QUOTIENT and MOD functions would work well to show you both full and partial tables.
Now you know how to divide in Excel, but you might want to learn more to truly master your spreadsheets.
What else can I learn?
We have in-depth guides on addition and subtraction in Excel, but you might be ready for bigger and better functions. A little instruction is all you need to work with PivotTables, Data Visualization, and more. If you’re keen for more knowledge, you might be interested in a new deal we’re highlighting from Tech Deals right now.
It’s called the Complete Excel Pro Tips Certification Bundle and it includes six hands-on modules to sharpen your skills. You can work through the skills mentioned above or even take more time practicing with formulas. You’re in the driver’s seat, so focus on what interests you.