|
Topic 18: How to Write an Excel Formula? |
Views: 1812
|
Thread Tools | Rate Thread |
#1
|
|||
|
|||
Topic 18: How to Write an Excel Formula?
What is Excel 2007 formula? and what it’s use for?
A formula is an equation that performs operations on worksheet data. You can use an Excel 2007 formula to perform mathematical operations, such as addition and multiplication, or they can compare worksheet values, join text, averaging a student's test results, etc. Formulas can refer to other cells on the same worksheet, cells on other sheets in the same workbook, or cells on sheets in other workbooks. In addition, if you change the data in your spreadsheet, Excel will automatically recalculate the answer without you having to re-enter the formula. A basic formula format will start with an equals sign (=) followed by one or more operands, separated by one or more operators. Operands can be values, text, cell references, ranges, defined names, or function names. Operators are symbols used to represent the various arithmetic and comparison operations you can perform on the operands. In Microsoft Excel 2007, operators are executed in this order: |
#2
|
|||
|
|||
To enter a formula
|
#3
|
|||
|
|||
To know the formula error messages
|