A formula can contain any or all of the following: functions, cell references, arithmetical operators, and constants (values that do not change). The arithmetical operators that are available include:
|
Operator |
Meaning |
Example |
Results (if A1 =10 and A2 =4 |
|---|---|---|---|
|
+ |
Addition |
=A1+A2 |
14 |
|
- |
Subtraction |
=A1-A2 |
6 |
|
* |
Multiplication |
=A1*A2 |
40 |
|
/ |
Division |
=A1/A2 |
2.5 |
|
% |
Percentage |
=A1% |
0.1 |
|
^ |
Exponentiation |
=A1^A2 |
10000 |