Formulas - Basic Operators
Desktop Apps Training - Calc

Formulas - Basic Operators

 

All the formulas in Calc begin with =, the = sign tells Calc that the string is a formula. Remember, without = the formulas will not work.

Operator
Description
= equals
^ exponent, the number on the left of the operator is raised to the power of the right number
* multiply
/ divide
+ add
- subtract
< less than
> greater than
<= less than or equal to
>= greater than or equal to
<> Not equal to
: Consecutive cells, A1:A9 will use cells A1 to A9
; Nonconsecutive cells to separate individual cells or formulas
! intersection

 

Examples:

 

=D1+D7 adds cells D1 and D7

=10^4 10 to the 4th power

=C3*C7 cell C3 is multiplied times C7

=E2/D4 cell E2 is divided by D4

=B4+B5 cell B4 is added to B5

=C18-C17 cell C17 is subtracted from C18