### Symbols Used in Excel Formula | The purpose of Symbols in Excel Formula

Following symbols are used in Excel Formula. They will perform different actions in Excel Formulas and Functions. Each of these special characters have used for different purpose in Excel.

SymbolNameDescription
=Equal toEvery Excel Formula begins with Equal to symbol (=).

Example:=B1+B6

()ParenthesesAll Arguments of the Excel Functions specified between the Parentheses.

Example:=COUNTIF(B1:B5,5)

()ParenthesesExpressions specified in the Parentheses will be evaluated first. Parentheses changes the order of the evaluation in Excel Formula.

Example: =25+(35*2)+5

*AsteriskWild card operator to to denote all values in a List.

Example: =COUNTIF(B1:B5,”*“)

,CommaList of the Arguments of a Function Separated by Comma in Excel Formula.

Example: =COUNTIF(B1:B5,“>” &C1)

&AmpersandConcatenate Operator to connect two strings into one in Excel Formula.

Example: =”Total: “&SUM(C2:C25)

\$DollarMakes Cell Reference as Absolute in Excel Formula.

Example:=SUM(\$C\$2:\$C\$25)

!ExclamationSheet Names and Table Names Followed by ! Symbol in Excel Formula.

Example: =SUM(Sheet2!C2:C25)

[]Square BracketsUses to refer the Field Name of the Table (List Object) in Excel Formula.

Example:=SUM(Table1[Column1])

{}Curly BracketsDenote the Array formula in Excel.

Example: {=MAX(B1:B5-G1:G5)}

:ColonCreates references to all cells between two references.

Example: =SUM(C2:C25)

,CommaUnion Operator will combine the multiple references into One.

Example: =SUM(A2:A25, B2:B25)

(space)SpaceIntersection Operator will create common reference of two references.

Example: =SUM(B2:B10 B5:B25)

1. Glad to visit this blog, really helpful. Gathered lots of information and waiting to see more updates.
PHP Trend
PHP Web Development Tool