1. Using Parentheses in Formulas
Parentheses () in Excel are mainly used to group operations and control calculation order.
a) Basic Arithmetic
=(10+5)*2
b) Nesting Parentheses
You can use multiple levels:
=((20+10)*(5-2))/2
Steps:
-
(20+10)=30
-
(5-2)=3
-
30*3=90
-
90/2=45.
Rule: Excel calculates inside-out.
2. Parentheses for Negative Numbers
Parentheses are commonly used in accounting to display negative numbers:
| Value |
Normal Format |
Accounting Format |
| 1000 |
1,000 |
1,000 |
| -1000 |
-1,000 |
(1,000) |
How to apply accounting style:
3. Custom Number Formats with Parentheses
You can automatically format negative numbers inside parentheses.
Steps:
-
Select cells → Ctrl+1 → Number tab.
-
Go to Custom.
-
Use a format like:
#,##0.00;(#,##0.00)
Explanation:
-
First part → positive numbers → #,##0.00
-
Second part → negative numbers → (#,##0.00)
-
Example: 1234.56 → 1,234.56
-1234.56 → (1,234.56)
4. Adding Parentheses Around Text
If you want to display parentheses in text or formulas:
a) In a formula:
="(" & A1 & ")"
If A1 = 2025, result → (2025).
b) Using TEXT function:
=TEXT(A1,"(0)")
If A1=50, result → (50).
5. Parentheses in Functions
Many Excel functions require parentheses for their arguments:
| Function |
Example |
Result |
| SUM() |
=SUM(A1:A5) |
Adds values |
| IF() |
=IF(A1>100,"Yes","No") |
Returns Yes/No |
| ROUND() |
=ROUND(A1,2) |
Rounds to 2 decimals |
| PMT() |
=PMT(5%/12,60,-30000) |
Loan payment |
Tip: Always ensure parentheses are balanced — Excel shows color-coded pairs when editing formulas.
6. Conditional Formatting with Parentheses
If you want numbers to automatically show parentheses based on a rule:
-
Select cells → Home → Conditional Formatting → New Rule.
-
Use Custom Number Format:
[>=0]#,##0;(#,##0)
