Friday, 16 January 2015

FORMULA

Okay. I have already discussed to you the basics in using Excel. Let's now go to Formula.

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