What does it do?

Divides two numbers

Formula breakdown:

=number1 / number2

What it means:

=the number being divided / the number you are dividing by

In Excel dividing numbers together is really easy!

The Division Formula is done through the use of the division operator which is depicted by a forward slash:  /

I will show you in the steps below how you can divide in Excel.

This is the table of values that we want to perform division on:

Division Formula in Excel

I explain how you can do this below:


STEP 1: We need to enter the number we want to divide:


Division Formula in Excel


STEP 2: Enter the division operator /

=C9 /

Division Formula in Excel


STEP 3: Enter the number we are dividing by:

=C9 / D9

Division Formula in Excel


Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the division results!

Division Formula in Excel


How to Use the Division Formula in Excel


How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga. There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas. This post will look at 10 rounding functions of Excel, and then look at some formatting te...
CountA Formula in Excel What does it do? Counts the number of cells that are non-blank/non-empty (including empty text "") Formula breakdown: =COUNTA(value1, , ...) What it means: =COUNTA(value or range of cells to check, , ...) Do you have a scenario where you want to count the nu...
Add Comma After the Surname with Excel’s SUB... What does it do? It replaces specific text in a text string i.e. Substitutes new text for old text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, From this TEXT character, To this TEXT character, )...
CountIfs Formula in Excel What does it do? Counts the number of cells that matches your specified conditions Formula breakdown: =COUNTIFS(range1, criteria1, , , ...) What it means: =COUNTIFS(range of cells to check1, condition to check against1, , , ...) Do you have a scenario where ...