Wednesday, March 21, 2012

How to Create Division Formulas in Cells in Microsoft Excel 2003


1. Choose the cells you wish to divide. Make sure the cells contain divisible dates.
2. Select a cell that will contain the formula. Pick an empty cell and left-click on it to activate and select it.
3. Create the division formula. In the blank cell, you will create a sum formula. The formula will have to include the cell you wish to divide and the cell that contains that division integer. A division formula for two cells would read like this: =Sum (D1/D2). This tells the spreadsheet to take the data contained in cell D1 and divide it by the data contained in cell D2. The program will place the results of the division operation into the blank cell in which you created the formula.
4. Implement the division formula. Once you are done entering the division formula, simply click on the 'Enter' key, and the formula will be implemented within your spreadsheet.

Blogger news