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 you can divide two numbers very easily using the Division formula!

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 numbers in Excel.

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

How to Divide in Excel with the Division Formula

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

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

=C9

How to Divide in Excel with the Division Formula

 

STEP 2: Enter the division operator /

=C9 /

How to Divide in Excel with the Division Formula

 

STEP 3: Enter the number we are dividing by:

=C9 / D9

How to Divide in Excel with the Division Formula

 

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!

How to Divide in Excel with the Division Formula

 

How to Use the Division Formula in Excel

How to Divide in Excel with the Division Formula

HELPFUL RESOURCE:

How to Divide in Excel with the Division Formula

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin