Page 83 - 2619_PlusGPT V2.1_C-7

3. =8 / 5 (Dividing 8 by 5)
4. =8 ^ 5 (Raising 8 to the power of 5)

The results will be 3, 40, 1.6 and 32768 respectively. Some formulas based on BEDMAS rule can be
entered as:
1. =(8 + 5) – (2 + 3) ^ 2
2. =(9/3) * (4 ^ 2) – 5

Tech Fact
Excel 2016 follows BEDMAS rule for doing mathematical calculations, where B stands
for Brackets, E for Exponentiation, D for Division, M for Multiplication, A for Addition
and S for Subtraction.

You can perform calculations using cell references in the following manner:

When you select a cell (like C1) in Google Sheets, you can see the formula you typed in the Formula
bar at the top of the screen. This is where the formula appears, and you can edit it directly if
needed.

A formula in Google Sheets is made up of three main elements:
1. References: These are the cells or ranges of cells you want to use in your calculation. For
example, A1 or B2:B5

2. Operators: These are symbols like +, -, *, /, ^, %, and others that define what kind of calculation
you want to do.
3. Constants: These are fixed numbers or text values that do not change, like 5 or "Hello".
These features are present in Google Sheets, and you can use them to create your own formulas

for calculations.

ORDER OF OPERATION

When you perform calculations using a formula in Google Sheets, the program follows certain
rules to decide the order in which calculations are done:
Parentheses: Google Sheets will calculate anything inside parentheses first. So, if you have a

formula like (5 + 5), Google Sheets will calculate the sum before doing anything else.
Multiplication and Division: Google Sheets calculates multiplication and division before
addition and subtraction.
Left to Right: If there are multiple operators with the same level of precedence (like addition
and subtraction), Google Sheets will calculate them from left to right.

Formulas and Functions in Google Sheets 81