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:

DOWNLOAD EXCEL WORKBOOK

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

=C9

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

HELPFUL RESOURCE:

oztraining_728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Add Leading Zeros in Excel Do you have a lot of numbers with an uneven number of digits in your Excel list?Do you want to make them uniform by adding leading zeros to them?Well, it's a pain to add zeros in front of them one by one!Thankfully, Excel allows you to add leading zeros with one singl...
Extract First Name From Full Name in Excel There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to manually get the first names one by one. Thank goodness there are formulas to make my life easier!In Excel, it's very easy to do that with the LEFT a...
Getting the remainder with Excel’s MOD Formu... What does it do?Gives you the remainder after dividing one number with anotherFormula breakdown:=MOD(number1, number2)What it means:=MOD(a number, divided by this number)In Excel it is very easy to divide two numbers.But how about if you need to ge...
CountIf Formula in Excel What does it do?Counts the number of cells that matches your specified conditionFormula breakdown:=COUNTIF(range, criteria)What it means:=COUNTIF(range of cells to check, condition to check against)Do you have a scenario where you want to count the num...