Difference between revisions of "Manuals/calci/ISINTEGER"

From ZCubes Wiki
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 03: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

  1. ISINTEGER(15) = true
  2. ISINTEGER(-34) = true
  3. ISINTEGER(1/2) = false
  4. ISINTEGER("78") = true

Related Videos

ISINTEGERS

See Also

References

Is Function