Question
What are Excel formula basics?
Answer
Formulas in Microsoft Excel begin with an equal sign. The equal sign tells Excel that the succeeding characters constitute a formula. If you don't enter the equal sign, Excel will treat your entry as text and the calculation will fail.
| Operations in Formulas |
Symbol Name and Purpose |
| : |
Colon |
| |
Single space |
| , |
Comma |
| - |
Negation (as in -1) |
| % |
Percent |
| ^ |
Exponentiation |
| * |
Multiplication |
| / |
Division |
| + |
Addition |
| - |
Subtraction |
| & |
Connects two strings of text |
| = |
Comparison (Equal to) |
| < |
Less than |
| > |
Greater than |
| >= |
Greater than or equal to |
| <= |
Less than or equal to |
| <> |
Not equal to |
For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3
If you need further assistance, please click the CTL Support Request button on this page