How and when to use Brackets () Commas (,) and Inverted commas ("") within excel formulas and function?

Contact Us

Bhandup (W): Dreams Mall, Opp BMC Market, Nr Bhandup Station, Mumabi 400078.
Thane (W): G-03, SAI Sagar App, Beside Sai Babab Mandir, Kalher Thane.

+91 9870419968

info@advancedexcelcourse.com





How and when to use Brackets () Commas (,) and Inverted commas ("") within excel formulas?


Most of the times we need to use commas , Inverted commas “ “ (quotation mark) and brackets () within a formula. Today, let's understand how it's used within a formula and its significant.

Brackets () : Generally used to ensure that the calculations are performed in a correct order. Excel by default use * and / before + and - sign

A B C
  1   Ex:1 Ex:2
2 10 10
3 20 20
4 30 30
5 Out Put 610 900
6 Formula Used =B2+B3*B4 =(C2+C3)*C4

As said Excel by default calculate * and / before + and - sing
In the Example1 Above : Excel calulated the formula as 30*20 =600, And then 600 + 10 = 610.

Where as in Example 2: Excel calulated the formula as 10+20 =30
And then 30 * 30 = 900

Putting brackets within a formula helps excel identify the proper order.


Commas , : Generally commas are used to pass a multiple arguments within a formula.

Inverted commas “ “quotation mark : Generally used to pass a text or blank argument within a formula

A B C
  1   Quality Score Result Formula Used
2 60% C =IF(A2>80%,"A",IF(A2>70%,"B","C"))
3 75% B =IF(A2>80%,"A",IF(A2>70%,"B","C"))
4 85% C =IF(A2>80%,"A",IF(A2>70%,"B","C"))

In the above example comma (,) is used to define a condition and inverted commas " " quotation mark is used to a pass text (A,B,C) within a formula





  • facebook
  • google+
  • Youtube
  • skype
  • whatsapp
  • mobile
  • mail