FORMULA / FORMULAE
– an expression used to perform calculations
– begin with an equal ( = ) sign
– Composed of operands and operators
– May contain constants, cell references, ranges, and grouping symbols
Example of Formulas
=96*69
=R7+P7
=Boys–Girls
=A8=C2
=B1/B7-A4+E3*3
Operators Precedence In Formulas
Mixed Operation
=15>10
=5=2
=0<>0
=8+7-3*8>5+1
=15/3-1<>(4+2)*2
(c) Sir Tom
No comments:
Post a Comment