FORMULA LANGUAGE
Numeric constants
A numeric constant consists of numeric and special characters, with no intervening spaces, that conform to the following rules:
Integer -- The characters 0 - 9 without intervening spaces comprise a positive integer.
Decimal -- A decimal point may be placed before, after, or within the numeric characters.
Sign -- The first character of a number may be a plus or minus sign.
Scientific notation -- A number may be suffixed by the letter E, an optional plus (default) or minus sign, and an integer.
The table below shows the acceptable formats for entering numbers.
Type of Number
Constant
Result
Decimal
.123
0.123
Integer
123
123
Negative number
-123.4
-123.4
Scientific notation
123E2, 123E-2
12300, 1.23
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary