Division Formula in Excel

It will help you to divides two numbers in Excel.

Previously In Excel FormulasHow to use AVERAGE Formula in Excel?

Division Formula breakdown:

=number1 / number2


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

Let me tell you that in Excel it is very easy to divide numbers. So, if you want to divide numbers in Excel then use Division Formula and most importantly you need to remember that it is done with the use of the division operator which is depicted by a forward slash in the Excel:  /

You need to follow these steps which is given below to use Division Formula in Excel.

STEP1: Working With Divide Function

Firstly, you will need to enter the number you want to divide into Excel:


Division Formula in Excel

Now continue by entering the division operator / the number you want to divide by;

=A2 / B2

Division Formula in Excel

Here is the result;

Division Formula in Excel

STEP2: Apply To All

By dragging the lower right corner downwards, you need to apply the same formula to the remaining cells of Excel Sheet. 

There you go with the results division formula.

Division Formula in Excel