Page 273 - Trackpad IT-402_Class-IX
P. 273
Order of precedence Operator
1 ()
2 ^
3 / *
4 +
In the above order of precedence, / and * are in the same order. Similarly, + and - are in the same order. In an expression,
if the operators of the same order are present, then the order of evaluation of the expression will be from left to right.
Let's see some examples given below:
Formula Evaluation Result
=5–4/2
=2+3-4/2 3
=5–2
=10+2*16/2
=10+2*4^2/2 =10+32/2 26
=10+16
=36–4/4
=6*6-(1+3)/2^2 35
=36–1
=3+5*16
=3+5*4^2 83
=3+80
=2+2-3^2+10
=10/5+2-(1+2)^2+10 =4–9+10 5
=–5+10
Find the answers for the given expressions:
uiz Bee a. =5+6^2*4-3
b. =(2+3–1)*6+2-12/6
c. =64/6+2*4-1
d. =7+2–1*1/1^2
Using Cell Address in Formula
Instead of giving direct values in a formula, we can also give addresses of the cells containing values. For example to
get the sum of the values in the cells A1 and A2, the formula =A1+A2 will be used in the cell A3.
Electronic Spreadsheet 273

