Difference between revisions of "Manuals/calci/ENFORCEINTEGER"
Jump to navigation
Jump to search
Line 24: | Line 24: | ||
! Nature !! Number !! ENFORCETYPE | ! Nature !! Number !! ENFORCETYPE | ||
|- | |- | ||
− | | | + | | integer|| -5.5 || -5 |
|- | |- | ||
− | | | + | | integer|| -4.5 || -4 |
|- | |- | ||
− | | | + | | integer|| -3.5 || -3 |
|- | |- | ||
− | | | + | | integer|| -2.5 || -2 |
|- | |- | ||
− | | | + | | integer|| -1.5 || -1 |
|- | |- | ||
− | | | + | | integer|| -0.5 || 0 |
|- | |- | ||
− | | | + | | integer|| 0.5 || 0 |
|- | |- | ||
− | | | + | | integer|| 1.5 || 1 |
|- | |- | ||
− | | | + | | integer|| 2.5 || 2 |
|- | |- | ||
− | | | + | | integer|| 3.5 || 3 |
|- | |- | ||
− | | | + | | integer|| 4.5 || 4 |
|- | |- | ||
− | | | + | | integer|| 5.5 || 5 |
|} | |} | ||
Latest revision as of 05:02, 14 April 2017
ENFORCEINTEGER(Number)
- is any real number.
Description
- This function converts or enforces the given number or set of numbers to an integer value.
- Integer is the number without any decimal or fractional part but it can be the natural number with positive or negative sign.
- If the is positive, it is retained as positive only.
- If the is negative, it is retained as negative only.
- Number 'zero' is natural number, neither positive nor negative.
- The argument can also be a result of any function.
Examples
- ENFORCEINTEGER(44) = 44
- ENFORCEINTEGER(-2.45) = -2
- ENFORCEINTEGER(4/7) = 0
- ENFORCEINTEGER(-20/6) = -3
- ENFORCEINTEGER(SUM([-5,-30])) = -35
For a set of numbers, the function displays a table as follows -
- ENFORCEINTEGER(-5.5..5.5)=
Nature | Number | ENFORCETYPE |
---|---|---|
integer | -5.5 | -5 |
integer | -4.5 | -4 |
integer | -3.5 | -3 |
integer | -2.5 | -2 |
integer | -1.5 | -1 |
integer | -0.5 | 0 |
integer | 0.5 | 0 |
integer | 1.5 | 1 |
integer | 2.5 | 2 |
integer | 3.5 | 3 |
integer | 4.5 | 4 |
integer | 5.5 | 5 |
Related Videos
See Also
References