Here are the important symbols used in Excel Formulas. Each of these special characters have used for different purpose in Excel. Let us see complete list of symbols used in Excel Formulas, its meaning and uses.
Symbols used in Excel Formula
Following symbols are used in Excel Formula. They will perform different actions in Excel Formulas and Functions.
| Symbol | Name | Description |
|---|---|---|
| = | Equal to | Every Excel Formula begins with Equal to symbol (=).
Example:=A1+A5 |
| () | Parentheses | All Arguments of the Excel Functions specified between the Parentheses.
Example:=COUNTIF(A1:A5,5) |
| () | Parentheses | Expressions specified in the Parentheses will be evaluated first. Parentheses changes the order of the evaluation in Excel Formula.
Example: =25+(35*2)+5 |
| * | Asterisk | Wild card operator to to denote all values in a List.
Example: =COUNTIF(A1:A5,”*“) |
| , | Comma | List of the Arguments of a Function Separated by Comma in Excel Formula.
Example: =COUNTIF(A1:A5,“>” &B1) |
| & | Ampersand | Concatenate Operator to connect two strings into one in Excel Formula.
Example: =”Total: “&SUM(B2:B25) |
| $ | Dollar | Makes Cell Reference as Absolute in Excel Formula.
Example:=SUM($B$2:$B$25) |
| ! | Exclamation | Sheet Names and Table Names Followed by ! Symbol in Excel Formula.
Example: =SUM(Sheet2!B2:B25) |
| [] | Square Brackets | Uses to refer the Field Name of the Table (List Object) in Excel Formula.
Example:=SUM(Table1[Column1]) |
| {} | Curly Brackets | Denote the Array formula in Excel.
Example: {=MAX(A1:A5-G1:G5)} |
| : | Colon | Creates references to all cells between two references.
Example: =SUM(B2:B25) |
| , | Comma | Union Operator will combine the multiple references into One.
Example: =SUM(A2:A25, B2:B25) |
| (space) | Space | Intersection Operator will create common reference of two references.
Example: =SUM(A2:A10 A5:A25) |
what is the symbol of average in excel?
You can use AVERAGE()Function to calculate Average in Excel. If you wants to show the Average Statistical Symbol (x-bar), You can insert from symbols. F7C2 is the Unicode Hexa character for X-bar symbol. Make sure that you have set the Symbol Font :MS Reference Sans Serif.
I have a workbook, where the original author used an @ sign in front of a function call in a formula. I can find no reference as to what the @ does, or how it is used. Any one know??
VBA Example: ActiveSheet.Range(“L2”).Formula = “=@CATEGORY($E2,LFC_AreaLU)”
Note: Category is a User Defined Function in the workbook.
@ is an Implicit Intersection Operator:
Implicit intersection operator: @
I have this formula, do you know what the al means in the formula ?
IF(E4=””,””,VLOOKUP(C4,al,5,0)*E4), can
It could be a defined Name or a name of the Table (List Object)