||Every Excel Formula begins with Equal to symbol (=).
||All Arguments of the Excel Functions specified between the Parentheses.
||Expressions specified in the Parentheses will be evaluated first. Parentheses changes the order of the evaluation in Excel Formula.
||Wild card operator to to denote all values in a List.
||List of the Arguments of a Function Separated by Comma in Excel Formula.
Example: =COUNTIF(A1:A5,“>” &B1)
||Concatenate Operator to connect two strings into one in Excel Formula.
Example: =”Total: “&SUM(B2:B25)
||Makes Cell Reference as Absolute in Excel Formula.
||Sheet Names and Table Names Followed by ! Symbol in Excel Formula.
||Uses to refer the Field Name of the Table (List Object) in Excel Formula.
||Denote the Array formula in Excel.
||Creates references to all cells between two references.
||Union Operator will combine the multiple references into One.
Example: =SUM(A2:A25, B2:B25)
||Intersection Operator will create common reference of two references.
Example: =SUM(A2:A10 A5:A25)
||Reference Operator to Refer Worksheet. For example, you can create a named range mySum =SUM(!$A$1:$D$1). When you type mySum in Sheet1 it sums the A1:D1 of Sheet1 and when you use this in Sheet2, it sums A1:D1 of Sheet2. You can explicitly refer the sheet name as prefixing the sheet name before !. Example :=SUM(Sheet2!$A$1:$D$1), when you use mySum in any sheet, it always Sums the values in Sheet2.
Relative Sheet Reference: mySum =SUM(!$A$1:$D$1)
Absolute Sheet Reference: mySum =SUM(Sheet2!$A$1:$D$1)
||Arithmetic Operator to perform Addition.
Examples: =A1+B1, will add the values of A1 and B1
||Arithmetic Operator to perform Substation.
Examples: =A1-B1, will Subtract the value of B1 from the value of A1
||Arithmetic Operator to perform Multiplication.
Examples: =A1*B1, will multiply the value of A1 with B1
||Arithmetic Operator to perform Division.
Examples: =A1/B1, will divide the value of A1 with B1
||Arithmetic Operator to perform Exponentiation.
Examples: =A1^B1, will calculate the exponential of A1 to the power of B1
||Error are returned when a formula returns multiple cells, and Excel cannot return the results to the Range. It is commonly due to the cells are already filled with some other data.
Examples: B1=A1:A5+10, This returns values in 5 cell (B1:B5), if any of the cell is there are any non blank cells in the target Range (B1:B5) then it returns #Spill Error