### 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.

## 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