- used to calculate
- begins with an = sign
- is made up of operands and operators
- may contain constants, cell references, ranges, and grouping symbol
Examples
=15*2 --- this will result with the cell containing the number 30
=A1+A2 --- the result will be the sum of the cells' value
List of Operators
Order of Operators
More Examples
="part"&B1 ---and the B1 containing "1", this will result to "part1"
=(1=1)+(1=1) ---this will result to "2", why? Because (1=1) is equal to true, which is equal to 1, so 1+1=2
Reference: http://moodle.pshs-brc.edu.ph/pluginfile.php/4746/mod_resource/content/0/Functions%20and%20Formula.pdf
