Makes the * or ? symbol literal in criteria writing Represents a wildcard operator in criteria writing (any one character) Make the row number or column letter on its right an absolute reference (won’t move when we copy the formula to other cells)Ĭoncatenate the data on the left with the data on the right Represents “more than” in a logic condition Makes the number on its left side a percentage Powers the number on the left with the level of the number on the right

Represents a wildcard operator in criteria writing (any character in any amount)ĭivides the number on the left with the number on the right Multiplies the number on the left with the number on the right Subtracts the number on the left with the number on the right Represents “equal to/the same as” in a logic conditionĪdds the number on the left with the number on the right Each symbol is explained with its name, meaning, and formula writing example to help you understand them better. Here is a table that lists the symbols you can use in an excel formula. List of Symbols in Excel Formula and Their Meanings

Commas in excel formulas