Wednesday, May 21, 2014

Divide Numbers in Excel

We know how to divide, by paper. Or, we can just try to solve the problem using the calculator. Now, can you divide in Excel? Well, multiplication is the opposite of division, and it does not mean you enter =PRODUCT(number1-number2). So, what is the formula? How do I do it? Well, let's see below.

Steps

  1. Divide Numbers in Excel Step 1.jpg
     
     
    Open Excel 2007 or 2010.
  2. Divide Numbers in Excel Step 2.jpg
     
     
    On any cell, type =QUOTIENT(numerator,denominator).
    • Replace numerator and denominator with the numbers you want to divide.
  3. Divide Numbers in Excel Step 3.jpg
     
     
    On the right of that cell, type =QUOTIENT(numerator,denominator) again.
    • Replace numerator and denominator with 2 numbers.
  4. Divide Numbers in Excel Step 4.jpg
     
     
    Now, on the right of the second cell, type the formula again. This time, type the two cells that you want to divide.
  5. Divide Numbers in Excel Intro.jpg
     
     
    Finished.
     
    Source : http://www.wikihow.com/Divide-Numbers-in-Excel

No comments:

Post a Comment