# Using Parentheses in Excel

Author:

How to use parentheses in Excel in order to create more powerful formulas and functions.

### Sections:

Basics of Parentheses

Using Parentheses with Logical Comparison Operators

Using Parentheses with Functions

Notes

## Basics of Parentheses

When performing calculations or doing anything in a formula or function or operation in Excel, what is inside parentheses will always be evaluated first.

If there are multiple parentheses in the same formula, they will be evaluated left-to-right.

If there are parentheses inside of parentheses, they will be evaluated inside-out, where the content inside the inner most parentheses is evaluated first, then the content in the next level of parentheses and so on until the last level of outer parentheses is reached.

## Using Parentheses with Logical Comparison Operators

You can use parentheses any time you need to group together a set of numbers, formulas, or functions, including when using comparison operators.  Nothing changes except that the formulas will look more complex.

### Example:

These are the same examples from the "Basic" section except, this time, there are logical comparison operators inside the formulas.  A7 uses the > sign; A8 uses the <> sign; A9 uses the <=.

Don't forget that logical comparisons, such as these only ever output TRUE or FALSE, so don't let that confuse you.

## Using Parentheses with Functions

You can put functions within parenthesis just like you can with numbers.

### Example:

It starts to get quite confusing the more parentheses you add and the more complex it becomes but, just remember how Excel calculates this, inside-out, and follow that in your mind to build the correct structure.

## Notes

Parentheses allow you to group elements in a cell.  This allows you to create more complex and more powerful formulas.  You can use them with basic formulas, logical operators, functions, anything.  All they do is group data, which changes the order in which that data is processed and calculated.

Make sure to download the spreadsheet that accompanies this tutorial so you can see the above examples in Excel.

#### Question? Ask it in our Excel Forum

Our Excel Courses

#### Professional Input Forms in Excel

• Skill Level: All Levels
• |
• 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

#### Send Emails from Excel (Multiple Methods)

• Skill Level: All Levels
• |
• 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Confirm User Input using VBA and Macros in Excel
Tutorial: View the Full VBA/Macro Course How to have a user confirm their input using vba - this fe...
Remove Dashed Lines from Copy Paste VBA in Excel
Tutorial: How to remove the flashing dashes from a copy/paste range using VBA in Excel; this removes...
Advanced Decision Making using CHOOSE in Excel
Tutorial: How to make decisions in Excel without using an IF statement; here, we use the CHOOSE() f...
How to Use Dates in Excel
Tutorial: Introduction Guide to using Dates in Excel - this tutorial will show you how to input and...
Select Ranges of Cells in Excel using Macros and VBA
Tutorial: This Excel VBA tutorial focuses specifically on selecting ranges of cells in Excel.  This...
Get the Last Row using VBA in Excel
Tutorial: How to find the last row of data using a Macro/VBA in Excel, including getting the number ...
Tutorial Details
Similar Content
Confirm User Input using VBA and Macros in Excel
Tutorial: View the Full VBA/Macro Course How to have a user confirm their input using vba - this fe...
Remove Dashed Lines from Copy Paste VBA in Excel
Tutorial: How to remove the flashing dashes from a copy/paste range using VBA in Excel; this removes...
Advanced Decision Making using CHOOSE in Excel
Tutorial: How to make decisions in Excel without using an IF statement; here, we use the CHOOSE() f...