How to Add Parentheses in Excel Formulas Correctly

Formulas & functions · Updated November 18, 2026

To add parentheses in an Excel formula, edit the cell, type an opening parenthesis where you want a calculation grouped, then type its matching closing parenthesis. For example, with 10 in A1, 5 in B1, and 2 in C1, the formula =(A1+B1)*C1 returns 30 because Excel adds A1 and B1 before multiplying. Parentheses can also be required around a function’s arguments, as in SUM(A1:A3).

What You’ll Need

You only need an Excel workbook and a cell containing, or ready to contain, a formula. These directions are for Microsoft Excel for Microsoft 365 on Windows. The same formula syntax works in Excel for Mac and Excel for the web; the editing shortcuts and available interface controls can differ slightly.

  • A worksheet with the values or cell references your formula will use.
  • A keyboard. On a standard US keyboard, type an opening parenthesis with Shift+9 and a closing parenthesis with Shift+0. The key combination may differ on other keyboard layouts.
  • A basic idea of the order in which you want Excel to calculate the parts of the formula.

Step-by-Step

  1. Select the formula cell. Click the cell that contains the formula you want to change. If you are starting from scratch, select a blank cell where the answer should appear. Check that you are not selecting a nearby cell that merely displays a value used by the calculation.
  2. Open the formula for editing. On Windows, press F2 or double-click the cell. You can also click in the Formula Bar above the worksheet. On a Mac, Control+U edits the active cell in Excel; double-clicking the cell or using the Formula Bar is another option. In Excel for the web, double-click the cell or edit in the Formula Bar.
  3. Find the operation you want Excel to do first. Parentheses group the part of a formula inside them, so Excel evaluates that part before operations outside the group. Identify the exact expression to group. For example, if a total must be multiplied by a rate, group the addition before the multiplication.
  4. Insert the opening parenthesis before the group. Click or move the insertion point immediately before the first cell reference or value that belongs in the group. Type (. Do not add a space or extra symbol unless the formula requires it. You can move through a formula with the arrow keys while editing, or click the relevant position in the Formula Bar.
  5. Insert the closing parenthesis after the group. Move the insertion point directly after the last part of the expression you want grouped and type ). Every opening parenthesis needs a corresponding closing parenthesis. If you are unsure where the group ends, read the expression from left to right and match each opening mark with the closing mark that completes that group.
  6. Check the complete formula. Read from the equals sign to the end. Confirm that the parentheses surround the intended references and operators, and that any function names still have their own parentheses around their arguments. Excel often highlights or visually matches a pair while you edit, but do not rely on color alone if the formula has several nested groups.
  7. Commit the change and inspect the result. Press Enter on Windows, or Return on a Mac, to enter the formula. In Excel for the web, press Enter as well. If you want to leave the cell without committing an edit, press Esc. Check the calculated value and, when necessary, compare it with a hand calculation using the same order of operations.
  8. Use a small example to verify the effect. With 10 in A1, 5 in B1, and 2 in C1, =(A1+B1)*C1 returns 30: Excel calculates 10 plus 5, then multiplies by 2. With the same cell values, =A1+B1*C1 returns 20 because multiplication happens before addition. The two formulas use the same references but group the arithmetic differently.
  9. Keep function parentheses separate from grouping parentheses. Function names such as SUM, IF, and AVERAGE are followed by parentheses containing their arguments. For example, with 4 in A1, 7 in A2, and 9 in A3, =SUM(A1:A3) returns 20. The parentheses here identify the function’s input range; they are part of the function syntax, rather than a way to group addition and multiplication.

Excel uses standard calculation precedence: parentheses set a group to calculate first, while multiplication and division normally take priority over addition and subtraction. Parentheses can therefore change a result, but they can also make an already-correct formula easier to read. If the formula contains nested groups, Excel evaluates the innermost group first, then works outward.

Common Mistakes

  • Adding only one side of a pair. An opening parenthesis without a matching closing one, or a closing parenthesis without an opening one, leaves the expression incomplete. Count the opening and closing marks before pressing Enter.
  • Putting the closing parenthesis in the wrong place. A group that ends too early may leave an operator outside the group and change the result. In the worked example above, grouping only A1 and B1 produces a different calculation from grouping a different part of the expression. Place the closing mark immediately after the last item that should be calculated together.
  • Removing parentheses required by a function. A formula function needs parentheses after its name to contain its arguments. Deleting those marks while trying to change calculation order can make the function invalid. Add extra grouping marks around an expression when needed, but keep the function’s own argument parentheses intact.
  • Confusing formula parentheses with displayed number formatting. A cell format can show a negative number in parentheses without changing the formula or the underlying value. If the goal is to change the calculation, edit the formula. If the goal is only to change how a negative value appears, adjust the number format instead.
  • Typing ordinary text instead of editing the formula. If the cell is not in edit mode, pressing the parenthesis keys may enter a new value or replace the selected cell content. Confirm that the insertion point is inside the existing formula before typing.
  • Using a separator that does not match the Excel region settings. The examples here use commas between function arguments. Some regional settings use semicolons instead. If Excel rejects an otherwise correctly structured function, check the list separator used by your installation rather than changing the parentheses.

Tips

  • Make the intended order visible. Add parentheses when a formula will be reviewed or maintained by someone else, even if Excel would calculate it the same way without them. For example, grouping a subtotal before multiplying can make the purpose of the calculation easier to follow.
  • Build complicated formulas in stages. Enter and verify a simpler version first, then add one pair of parentheses at a time. This makes it easier to identify which edit changed the answer or introduced a syntax problem.
  • Use the Formula Bar for long expressions. The Formula Bar gives you more room to inspect a formula than the worksheet cell does. Click inside it to place the insertion point, then check both sides of the group before confirming the edit.
  • Read nested groups from the inside out. When parentheses are nested, find the innermost pair first. Check that inner calculation, then follow the surrounding operators out to the full formula. This is clearer than trying to interpret every part at once.
  • Compare a result with a simple hand calculation. For a short expression, work through the grouped operations on paper. If the worksheet result differs, inspect the cell references and the placement of each pair before changing values or formats.
  • Remember that parentheses are not decorations. They can alter calculation order, so do not add them randomly to make a formula look more complex. Add them around the expression that must be treated as one unit, and keep the formula as easy to read as possible.

Troubleshooting

Excel says there is a problem with the formula. Reopen the cell and count the parentheses from left to right. Each opening mark should have a closing match, and nested pairs must close in the correct order. Also check that you have not deleted a function’s argument parentheses or placed a parenthesis inside a cell reference by mistake. If the formula uses a function with multiple arguments, confirm whether your Excel settings expect commas or semicolons between those arguments.

The formula is accepted, but the answer is unexpected. Check which exact terms are inside the parentheses, then write out the calculation in that order. Confirm that the formula points to the intended cells and that those cells contain the values you expect. A formula can be syntactically valid yet produce a different result because the closing parenthesis groups more or less of the expression than intended.

The cell displays the formula instead of its result. Make sure the cell is not formatted as Text. Change its format to General using Home > Number Format, then edit the cell and press Enter so Excel recalculates it. Also check that the formula begins with an equals sign. If Show Formulas is enabled, press Ctrl+` on Windows to toggle it off; the accent key is usually near the top-left of a US keyboard. On a Mac, the shortcut can depend on keyboard layout and Excel settings, so use Formulas > Show Formulas if that command is available in the ribbon.

The parentheses appear to move or disappear. Excel may adjust the way it displays a formula while editing, or the cursor may be in a different position than expected. Click in the Formula Bar, use the arrow keys to locate the exact insertion point, and inspect the full expression before committing. If you are unsure what changed, press Esc before confirming and reopen the original formula.

The answer is correct but the formula looks crowded. Parentheses do not create line breaks in a formula. Use the Formula Bar to review it, or simplify the calculation into helper cells if doing so makes the worksheet easier to audit. Keep the original logic intact and verify the final result after reorganizing the formula.

Frequently Asked Questions

Do parentheses change the order of operations in Excel?
Yes. Excel evaluates the expression inside parentheses before operations outside them. This can change the result when the formula combines operations with different precedence, such as addition and multiplication.

Can I add parentheses around an entire formula?
Often, yes, but it may not change the calculation. Parentheses are most useful around a specific part that must be calculated first, or when the syntax of a function requires them. Avoid adding unnecessary pairs that make a formula harder to read.

How do I type parentheses while editing a formula?
On a standard US keyboard, use Shift+9 for the opening parenthesis and Shift+0 for the closing parenthesis. On Mac and Windows, those keys work the same way with a US layout. Other layouts may place the characters elsewhere; use the keyboard’s indicated characters.

Why does Excel need parentheses after a function name?
Those parentheses enclose the function’s inputs, also called its arguments. For example, with 82 in A2, =IF(A2>=70,"Pass","Review") returns Pass. The function’s parentheses are required syntax; additional pairs can group calculations within an argument.

Can parentheses make Excel show negative numbers differently?
Yes, number formatting can display negative values inside parentheses, but that changes only the appearance, not the formula’s calculation. Use formula parentheses when changing calculation order; use cell number formatting when changing how a value is displayed.

Do the same formula parentheses work in Excel for Mac and the web?
Yes. Parentheses are part of Excel formula syntax, so the examples work in Microsoft 365 for Windows, Mac, and the web. The main differences are how you enter or edit a formula and, depending on regional settings, which argument separator your installation expects.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.