How to Divide in Excel

In order to divide in Excel you simply use the / operator. An example of this is shown in the spreadsheet on the right. This formula, consists of the = sign, followed by two numbers, separated by the / operator.

This simple Excel division formula divides the number 15 by the number 4, and returns the result 3.75.

  A B
1 = 15 / 4  
2    
3    

As with all Excel formulas, instead of typing numbers directly into the formula, you can use references to cells containing numbers.

An example of how to divide in Excel, using numbers that are stored in cells, is shown in cell A1 of the spreadsheet on the right. This division formula divides the number in cell B1 by the number in cell B2. Again, the formula returns the value 3.75.

  A B
1 = B1 / B2 15
2   4
3    







Return to the Excel Formulas Page

Return to the ExcelFunctions.net Home Page

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net