Excel formula symbols are operators and reference markers that tell Excel what to calculate or which cells to use. The main ones are arithmetic symbols such as + and *, comparison symbols such as > and <=, the text-joining symbol &, and reference symbols such as :; newer Excel formulas also use @ and # in specific ways.
What counts as a formula symbol?
A formula is an instruction Excel evaluates, usually beginning with an equals sign. Within it, symbols can perform arithmetic, compare values, join text, or describe a range of cells. Some visible marks have different jobs: the dollar sign in a reference fixes a row or column, while commas inside a function usually separate its arguments rather than perform a calculation.
It helps to distinguish operators from punctuation. In a function call, parentheses enclose the inputs and commas separate them in many regional settings. A colon can describe a range, while an exclamation mark separates a worksheet name from a cell reference. These marks all appear in formulas, but they do not all mean the same thing.
On Microsoft 365 for Windows, the usual formula argument separator is a comma, but Excel can use a semicolon depending on Windows regional settings. Mac and Excel for the web can also follow regional or application settings. If a formula copied from a website is rejected, the separator may be the issue rather than the function itself.
Arithmetic operators
Arithmetic symbols make Excel calculate numbers. The standard operators are addition (+), subtraction (-), multiplication (*), division (/), exponentiation (^), and percent (%). Excel uses an asterisk for multiplication, not the letter x, and a slash for division.
+adds values.-subtracts one value from another; before a number or reference, it can also make that value negative.*multiplies./divides.^raises a number to a power.%treats a number as a percentage, so 25% represents 0.25.
With 12 in A2 and 5 in B2, this formula returns 17:
With 12 in A2 and 5 in B2, enter =A2+B2 in C2; the result is 17.
With 12 in A2 and 5 in B2, enter =A2*B2 in C2; the result is 60. If A2 contains 12, =A2^2 returns 144. These examples show why the symbol matters: using + instead of * changes the operation, not just the appearance of the formula.
With 80 in A2 and 15% in B2, enter =A2*B2 in C2; the result is 12. A percentage is stored as a decimal value for calculation, even if the cell displays a percent sign.
Comparison operators
Comparison operators test whether one value relates to another. Their result is TRUE or FALSE, and they are often used in IF formulas, filters, and conditional calculations.
=means equal to.>means greater than;<means less than.>=means greater than or equal to;<=means less than or equal to.<>means not equal to.
With 72 in A2, enter =A2>=70 in B2; Excel returns TRUE. With the same value, =A2<>70 returns TRUE because 72 is not 70. In formulas, comparison symbols must be written in the correct order: greater than or equal to is >=, not =>.
To compare text, put the text in straight double quotation marks. With the word Paid in A2, =A2="Paid" returns TRUE. Text comparisons are not generally case-sensitive in ordinary Excel comparisons, so Paid and PAID are treated as equal in this kind of test.
Joining text with the ampersand
The ampersand (&) joins text values. It is useful for combining names, labels, and cell contents without using a function. If A2 contains Maya and B2 contains Chen, enter =A2&" "&B2 in C2; the result is Maya Chen. The quoted space inserts a gap between the two cell values.
Numbers can be joined to text as well, but the result is text rather than a number that can be added directly. With 12 in A2, enter ="Items: "&A2 in B2; the displayed result is Items: 12. If you need a particular number format in the joined text, use the TEXT function to specify a format; simply joining a cell may not preserve its displayed currency or date format.
Reference symbols: ranges, sheets, and fixed cells
Some symbols describe where data is located instead of performing arithmetic. A colon between two cell addresses identifies a range. With values in A2 through A6, enter =SUM(A2:A6) in B2; Excel adds all five cells. The colon means from the first reference through the second, including the cells in between.
An exclamation mark separates a worksheet name from a cell or range reference. If a worksheet is named Sales Data and its B2 cell contains 250, enter ='Sales Data'!B2 on another sheet to refer to that cell. The single quotation marks are needed because the sheet name contains a space; a simple sheet name such as Sales does not require them.
The dollar sign ($) marks an absolute reference. It is not an arithmetic operator. In a reference such as $E$1, both the column and row stay fixed when the formula is copied. A reference such as E$1 fixes only the row, while $E1 fixes only the column.
With a price in B2 and a tax rate of 8% in E1, enter =B2*$E$1 in C2. If B2 is 50, the result is 4. When the formula is copied down, the B2 reference adjusts to B3, B4, and so on, but $E$1 remains fixed. In Excel for Windows, F4 while editing or selecting a reference cycles through the relative and absolute forms; on Mac, the equivalent is commonly Command+T, though keyboard behavior can depend on the keyboard and Excel settings.
Commas, spaces, and parentheses
A comma has more than one possible role. In a function such as SUM, it commonly separates arguments: each item is an input to the function. In a reference expression, a comma can represent a union, meaning more than one selected range. The surrounding formula context determines its meaning. Some regional configurations use semicolons between function arguments, so a comma shown in an example may need to be changed to a semicolon on that system.
A space can act as the reference intersection operator, selecting cells shared by two ranges. This is less common in everyday formulas and easy to confuse with a typing error. Parentheses group parts of a formula and can change the order of calculation. With 2 in A2 and 3 in B2, enter =A2+B2*4 in C2; the result is 14 because multiplication happens before addition. Enter =(A2+B2)*4 in D2; the result is 20 because the parentheses make Excel add first.
When a formula has several operations, parentheses are a good way to make the intended order visible, even when they are not strictly required. They also make long formulas easier to inspect and reduce the chance that a later edit changes the calculation accidentally.
What @ and # mean in modern Excel
In Microsoft 365, the at sign (@) can indicate implicit intersection: Excel returns the value relevant to the current row or cell from a range or array. It can also appear in an Excel table formula to refer to the current row. These uses are related to selecting a value in context, but they are not interchangeable in every formula.
If an Excel table has columns named Quantity and Price, enter =[@Quantity]*[@Price] in the table’s Amount column. For a row with Quantity 3 and Price 8, the result is 24. The @Quantity and @Price references mean the values from those columns on that same table row. Excel usually fills the calculated-column formula down the table.
The hash symbol (#) can refer to a spilled array range. A dynamic-array formula in A2 might return several results into cells below it; a reference to A2 with # means the whole spill range, not just its first cell. If A2 is the top-left cell of a spill containing 10, 20, and 30 in A2:A4, enter =A2# in C2; the reference returns that three-cell array. The spill area must be clear, or Excel may show a spill error.
Operator order and common mistakes
Excel follows a calculation order: references and ranges are resolved, percentages and powers are evaluated, multiplication and division are handled, then addition and subtraction, followed by text joining and comparisons. Operations at the same level are generally evaluated from left to right. Parentheses take priority and are the clearest way to specify a different order.
Common issues often come from mixing up a symbol’s role or using a look-alike character. Check these points when a formula does not work as expected:
- Start a calculation with
=. Without it, Excel may treat the entry as ordinary text. - Use
*for multiplication and^for powers; Excel does not interpret x as a multiplication operator. - Use straight quotation marks around text criteria, not typographic curly quotation marks copied from a word processor.
- Check whether your Excel setup expects commas or semicolons between function arguments.
- Use a colon for a continuous range, such as A2:A10; it includes the cells between both endpoints.
- Do not confuse $ in a cell reference with currency formatting. The dollar sign in $A$1 controls copying behavior; currency formatting changes how a value is displayed.
If Excel displays the formula characters in the cell instead of calculating them, check whether the cell is formatted as Text or whether a leading apostrophe was entered. Change the cell format to General, then re-enter the formula. A displayed error such as #N/A is different: it is an error value produced by a calculation or lookup, not an operator that should be inserted to make a formula work.
Frequently Asked Questions
What symbol starts an Excel formula?
Most Excel formulas begin with an equals sign (=). Type it before a calculation, cell reference, or function name so Excel evaluates the entry as a formula.
What does $ mean in an Excel formula?
The dollar sign locks the row, column, or both in a cell reference when the formula is copied. For example, $A$1 keeps both parts fixed, while A$1 locks only the row.
What does & do in Excel?
The ampersand joins text values. It can combine cell contents with other text, including a quoted space, but the combined result is text.
What is the difference between : and , in a formula?
A colon usually identifies a continuous range, such as A2:A8. A comma commonly separates function arguments and can also mean a union in a reference expression; the exact role depends on context and regional settings.
What do @ and # mean in Excel?
@ can select a value in the current row or context, including a current-row value in a table formula. # can refer to the full spilled range produced by a dynamic-array formula.
Why does Excel show a formula instead of its answer?
The cell may be formatted as Text, may contain a leading apostrophe, or Excel may have Show Formulas enabled. Check the cell format and formula entry first, then look for the Show Formulas command on the Formulas tab if formulas are displayed throughout the sheet.
Related
- Randomize Numbers in Excel Without Duplicates
- Rank in Excel: How to Rank Values Largest to Smallest
- Randomize Names in Excel Without Repeats: Easy Methods
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Delete Every X Rows: Safe Methods and FormulasYes. In Microsoft Excel for Microsoft 365 on Windows, add a helper column to mark every xth data…
- How to Count Unique Values in a Row in Excel EasilyTo count distinct, nonblank values across a row in Microsoft 365, use =IFERROR(COLUMNS(UNIQUE(FILTER(B2:K2,B2:K2<>""))),0). This assumes the values are…
- How to Filter Highest to Lowest in Excel: A Quick GuideTo show the largest values first in Excel, open the filter arrow on the column you want to…
- SUMIF in Excel: Step-by-Step Formula, Examples, and TipsTo total values that match one condition in Excel, use SUMIF. If categories are in A2:A7 and amounts…
- Excel INDEX MATCH Examples and How to Use ThemIn Excel, INDEX MATCH looks up a value by finding its position with MATCH and returning the value…
- Excel Data Validation INDIRECT: Dependent Drop-DownsYes. In Excel, use INDIRECT in a data-validation list to make a drop-down depend on a selection in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.