Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Entering Excel Formulas.
Posted by - NA - on 30 March 2006 07:52 AM
|
|
|
Solution: Excel has no special requirements when it comes to entering formulas. The one always necessary item is the equal sign (=). All formulas must begin with an equal sign. Although Excel will display all formulas in uppercase in the Formula Bar, Excel doesn't care about the case at all. When you enter formulas, you can save yourself some trouble by just entering them in lowercase. All formulas (sum, average, etc.) place data cells in parentheses. For example =sum (a1:a5) works, but =sum a1:a5 won't work | |
 (151 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)