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.

Symbol	Name	Description
=	Equal to	Every Excel Formula begins with Equal to symbol (=). Example:=B1+B6
()	Parentheses	All Arguments of the Excel Functions specified between the Parentheses. Example:=COUNTIF(B1:B5,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(B1:B5,”*“)
,	Comma	List of the Arguments of a Function Separated by Comma in Excel Formula. Example: =COUNTIF(B1:B5,“>” &C1)
&	Ampersand	Concatenate Operator to connect two strings into one in Excel Formula. Example: =”Total: “&SUM(C2:C25)
$	Dollar	Makes Cell Reference as Absolute in Excel Formula. Example:=SUM($C$2:$C$25)
!	Exclamation	Sheet Names and Table Names Followed by ! Symbol in Excel Formula. Example: =SUM(Sheet2!C2:C25)
[]	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(B1:B5-G1:G5)}
:	Colon	Creates references to all cells between two references. Example: =SUM(C2:C25)
,	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(B2:B10 B5:B25)