How to Make Formulas In A Microsoft Excel Spreadsheet

Below are ways of entering formulas into a Microsoft Excel Spreadsheet.

Difficulty: Moderate

Instructions

1. To duplicate a cell, click on the cell that is to reflect the duplication and type: = (Column Letter) (Row Number) From here on, I will refer to (Column Letter)(Row Number) as Cell Value.
   
   EX: To duplicate the value or formula in cell J8 into J120, click in cell J120 and type: =J8
   
   If there is text or non-formula data in J8, J120 will reflect its exact value.
   
   But if there is a formula in J8, J120 will reflect its formula – but not the resulting value from the formula in J8.
   
   
   Within One Spreadsheet/Worksheet, you can duplicate cells for the following reasons: (1) To enable a cell to reflect the value of its duplicated cell. (2) To enable a cell to reflect the value of its duplicated cell every time the duplicated cell is changed. The duplicate will reflect the duplicated cell each time a change is made. (3) If the spreadsheet is a very large document, the typist won’t have to navigate through several columns or rows in order to type the same data needed in another cell. So, the formula (the command to duplicate) can always be entered before data is to be entered.

2. Excel can be treated like a calculator for figuring data before entering.
   
   While you type in your data, you can click on a cell a few rows down to calculate numbers.
   
   EX: When calculating, type: + (Number) with any formula OR = (Number) with any formula. To calculate a multiplication, type: =5*783 OR + 5*783
   Simple as that.
   
   Enter the following symbols to make a formula involving multiplication and division.:
   *=multiplication, /=division

3. To sum up a group of cells, type: =Beginning Cell Value:Ending Cell Value
   
   So, if you are trying to sum up cells in Row 10 of columns A, B, C, and D on Row 10, then you will type into a selected cell (into a cell not within columns A thru D):
   
   =sum(A10:D10)
   
   Likewise, if you want to sum up cells in rows 8 through 50 of column B, then you will type into a selected cell (into a cell not within rows 8 thru 50):
   
   =sum(B8:B50)

4. You can also sum up cells individually. For the cells in Columns A, B, C, and D on Row 10, you can type in a selected cell:
   
   =A10+B10+C10+D10
   
   You can also skip around typing cell values into a selected cell: =A10+B11+B12+B19+J23

[bfreethree]

on 9/21/2009 Thank you for the article 'How to Make Formulas In A Microsoft Excel Spreadsheet'. I need this information. 5*