<< Chapter < Page | Chapter >> Page > |
To perform basic mathematical operations, use the following arithmetic operators.
Arithmetic Operator | Meaning (example) |
---|---|
+ (Plus sign) | Addition (3+3) |
- (Minus sign) | Subtraction (3-1) or negation (-1) |
* (Asterisk) | Multiplication (3*3) |
/ (Forward slash) | Division (3/3) |
% (Percent sign) | Percent (20%) |
^ (Caret) | Exponentiation (3^2) |
We can compare two values with the following operators, the result is a logical value either TRUE or FALSE.
Comparison operator | Meaning (example) |
---|---|
= (Equal sign) | Equal to (A1=B1) |
>(Greater than sign) | Greater than (A1>B1) |
(Less than sign) | Less than |
>= (Greater than or equal to sign) | Greater than or equal to (A1>=B1) |
Less than or equal to sign) | Less than or equal to |
(Not equal to sign) | Not equal to |
Depending on the type and version of spreadsheet application you are using workbook window will contain many elements. Some of the major elements are illustrated below.
Notification Switch
Would you like to follow the 'Engineering computation with spreadsheets' conversation and receive update notifications?