Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill Excel Move Cells Excel Add Cells Excel Delete Cells Excel Undo Redo Excel Formulas Excel Relative Reference Excel Absolute Reference Excel Arithmetic Operators Excel Parentheses Excel Functions

Excel Formatting

Excel Formatting Excel Format Painter Excel Format Colors Excel Format Fonts Excel Format Borders Excel Format Numbers Excel Format Grids Excel Format Settings

Excel Data Analysis

Excel Sort Excel Filter Excel Tables Excel Conditional Format Excel Highlight Cell Rules Excel Top Bottom Rules Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts

Table Pivot

Table Pivot Intro

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR

Excel How To

Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates

Guided Projects

Introduction to Excel Learn Data Calculations Learn Data Visualization Learn to Create a Budget Learn to Create a Timeline Learn to Style in Excel

Excel Examples

Excel Exercises Excel Certificate

Excel References

Excel Keyboard Shortcuts


Excel Parentheses


Parentheses

Parentheses () is used to change the order of an operation.

Using parentheses makes Excel do the calculation for the numbers inside the parentheses first, before calculating the rest of the formula.

Parentheses are added by typing () on both sides of numbers, like (1+2).

Examples

No parentheses

=10+5*2

The result is 20 because it calculates (10+10)

With parentheses

=(10+5)*2

The result is 30 because it calculates (15)*2

Formulas can have groups of parentheses.

=(10+5)+(2*4)+(4/2)

Note: Cells can be used as values in the formulas inside parentheses, like =(A1+A2)*B5. We have used manual entries in our examples to keep things simple.

Let's have a look at some real examples in Excel.


Without Parentheses

The result is 17, the calculation is 2+15. It uses 15 because 3*5=15.


With One Parentheses

The result is 25, the calculation is 5*5. It uses 5 because it has calculated numbers inside the parentheses (2+3)=5 first.



With Many Parentheses

The result is 17, the calculation is 5+8+4. The numbers inside the parentheses are calculated first.


Nesting Parentheses

When using more advanced formulas you may need to nest parentheses. You can look at this like an onion, which has many layers. Excel will calculate the numbers inside the parentheses first, layer by layer, starting with the inner layer.

Example no nesting

=2*2+3*4+5*5*2

It calculates the values flat as you would do with a calculator.

Example nesting

=((2*2)+(3*4)+(5*5))*2

Let's break it down and explain.

Nesting creates layers like an onion. You can have many layers. This example uses two, the inner and outer layers.

It starts with calculating the numbers in the inner layer:

  1. =((2*2)+(3*4)+(5*5))*2
  2. =((4)+(12)+25))*2 Calculates the inner layer
  3. =(41)*2 Calculates the outer layer
  4. 82

Chapter Summary

Parentheses can be used to change the order of an operation. The numbers inside the parentheses gets calculated first. A formula can have sets of parentheses. More advanced formulas can use nesting to create layers of operations, like an onion. It calculates the inner layer first, then the next, and so on.


Test Yourself With Exercises

Excel Exercise:

Type the value that the formula returns: =10+10*2



Start the Exercise