Difference between revisions of "Manuals/calci/ISINTEGER"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''ISINTEGER (Number)'''</div><br/> *<math>Number</math> is any number to test. **ISINTEGER(), returns TRUE if the number is an Integer. ==Descrip...") |
|||
(One intermediate revision by the same user not shown) | |||
Line 14: | Line 14: | ||
*For e.g. "20" is normally converted as a number 20. | *For e.g. "20" is normally converted as a number 20. | ||
*But in ISINTEGER("20") will return TRUE, because "20" will convert in to number. | *But in ISINTEGER("20") will return TRUE, because "20" will convert in to number. | ||
+ | |||
+ | ==Safe Integer== | ||
+ | '''SAFEINTEGER (Number)''' | ||
+ | *<math>Number</math> is to be tested as a secure integer. | ||
+ | *This function determines whether the provided value is a secure integer. | ||
+ | *A safe whole number is one that can be represented exactly by a double precision number. | ||
+ | *Safe integers consist of all integers from inclusive to inclusive.-(2^53 - 1)2^53 - 1 | ||
+ | * ISSAFEINTEGER("15") = true | ||
+ | * ISSAFEINTEGER("15.34") = false | ||
+ | |||
+ | ==Abundant Numbers== | ||
+ | *Abundant number is a number for which the sum of its proper divisors is greater than the number itself. | ||
+ | *It is also called Excessive Number. | ||
+ | *The first Abundant number is 12. | ||
+ | *ISABUNDANTNUMBER(6) = false | ||
+ | *ISABUNDANTNUMBER(20) = true | ||
+ | * ISABUNDANTNUMBER(1..12) = false false false false false false false false false false false true | ||
+ | |||
+ | |||
+ | |||
+ | ==Deficient Numbers== | ||
+ | *Deficient number is a number <math>n</math> for which the sum of divisors <math>\sigma(n)<2n</math>, or, equivalently, the sum of proper divisors (or aliquot sum) <math>s(n)<n</math>. The value <math>2n</math> − <math>\sigma(n)</math> (or <math>n</math> − <math>s(n)</math>) is called the number's deficiency. | ||
+ | *ISDEFICIENTNUMBER(6) = false | ||
+ | *ISDEFICIENTNUMBER(1..10) = false true true true true false true true true true | ||
==Examples== | ==Examples== |
Latest revision as of 02:01, 12 February 2020
ISINTEGER (Number)
- is any number to test.
- ISINTEGER(), returns TRUE if the number is an Integer.
Description
- This function is one of the group in ISFUNCTIONS.
- The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
- ISINTEGER function can be used to check the given value is integer or not.
- Here the number can be either positive or negative.
- This function gives the result as only TRUE or FALSE.
- The result is TRUE when the n value is Integer otherwise the result is FALSE.
- The argument can be blank, or it can contain data such as text, numbers, error values, logical values or any equations.
- This function will convert any numbers from text.
- For e.g. "20" is normally converted as a number 20.
- But in ISINTEGER("20") will return TRUE, because "20" will convert in to number.
Safe Integer
SAFEINTEGER (Number)
- is to be tested as a secure integer.
- This function determines whether the provided value is a secure integer.
- A safe whole number is one that can be represented exactly by a double precision number.
- Safe integers consist of all integers from inclusive to inclusive.-(2^53 - 1)2^53 - 1
- ISSAFEINTEGER("15") = true
- ISSAFEINTEGER("15.34") = false
Abundant Numbers
- Abundant number is a number for which the sum of its proper divisors is greater than the number itself.
- It is also called Excessive Number.
- The first Abundant number is 12.
- ISABUNDANTNUMBER(6) = false
- ISABUNDANTNUMBER(20) = true
- ISABUNDANTNUMBER(1..12) = false false false false false false false false false false false true
Deficient Numbers
- Deficient number is a number for which the sum of divisors , or, equivalently, the sum of proper divisors (or aliquot sum) . The value − (or − ) is called the number's deficiency.
- ISDEFICIENTNUMBER(6) = false
- ISDEFICIENTNUMBER(1..10) = false true true true true false true true true true
Examples
- ISINTEGER(15) = true
- ISINTEGER(-34) = true
- ISINTEGER(1/2) = false
- ISINTEGER("78") = true
Related Videos
See Also
References