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
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
|1||Quality Score||Result||Formula Used|
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