500 + 100
Interpreted as 600.0000.Arithmetic Operations
This manual is in pilot operation.
|
You can perform addition, subtraction, multiplication, and division on numbers.
-
The symbols for addition, subtraction, multiplication, and division are +, -, *, /.
-
Decimal places are limited to four. In multiplication and division, the fifth decimal place is rounded off.
-
When performing arithmetic operations on boolean values, they are converted to numbers before calculation.
-
If numerical operations are performed on string values, the result will be an error value (
#VALUE!will be displayed). -
When numerical operations are performed on a cell range object, the aggregate values of the cell range are used.
-
If numerical operations are performed on objects other than cell ranges, the result will be an error value (
#VALUE!will be displayed).
In addition, + and - can also be used as unary operators (sign operators).
- (500 + 100) (1)| 1 | Interpreted as -600.0000. |
+ (500 + 100) (1)| 1 | Interpreted as 600.0000. |