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

RANDBETWEEN Function for Excel Dates What does it do?Generates random dates, in between a start date and an end dateFormula breakdown:=RANDBETWEEN(bottom, top)What it means:=RANDBETWEEN(starting date for random date generation, end date for random date generation) If you need to ...
Cleaning Data with Excel’s CLEAN Formula  What does it do?Removes all nonprintable characters from textFormula breakdown:=CLEAN(text)What it means:=CLEAN(this dirty text cell)There are times when imported text from other applications contain characters that are unprintable. The CLEAN...
Extract Last Name with Excel’s REPLACE Formula What does it do?Replaces part of a text string, based on the number of characters you specify, with a different text stringFormula breakdown:=REPLACE(old_text, start_num, num_chars, new_text)What it means:=REPLACE(this cell, starting from this number, all the ...
Extracting Data with Excel’s LEFT Formula What does it do?It returns the first character or characters in a text string, based on the number of characters you specify.Formula breakdown:=LEFT(text, )What it means:=LEFT(look in this cell, extract X characters)There are times when you will need t...