Let's say you want to find out how many person hours it took to finish a project (total project hours ÷ total people on project) or the actual miles per gallon rate for your recent crosscountry trip (total miles ÷ total gallons). There are several ways divide numbers.
What do you want to do?
Divide numbers in a cell
Divide cells in a range
Divide numbers in a cell
To do this task, use the / (forward slash) arithmetic operator.
For example, if you type the following formula in a cell:
=10/5
The cell displays the following result:
2
Top of Page
Divide cells in a range
Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
 Create a blank workbook or worksheet.
 Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 In the worksheet, select cell A1, and press CTRL+V.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

A 
Data 
15,000 
12 
Formula 
Description (Result) 
=A2/A3 
Divides 15,000 by 12 (1250) 

Top of Page