Difference between revisions of "Manuals/calci/ISPERFECTNUMBER"
Jump to navigation
Jump to search
(Created page with "==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 fun...") |
|||
| Line 6: | Line 6: | ||
*The result is TRUE when the n value is a perfect number otherwise the result is FALSE. | *The result is TRUE when the n value is a perfect number 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. | *The argument can be blank, or it can contain data such as text, numbers, error values, logical values or any equations. | ||
| + | |||
| + | ==Examples== | ||
| + | #=ISPERFECTNUMBER (496) = true | ||
| + | #=ISPERFECTNUMBER (5) = false | ||
| + | #=ISPERFECTNUMBER (0) = false | ||
| + | #=ISPERFECTNUMBER (-6) = false | ||
| + | #=ISPERFECTNUMBER (6) = true | ||
| + | #=ISPERFECTNUMBER (500) = false | ||
Revision as of 02:13, 14 March 2017
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.
- ISPERFECTNUMBER function can be used to check the given value is a perfect number or not.
- This function gives the result as only TRUE or FALSE.
- The result is TRUE when the n value is a perfect number 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.
Examples
- =ISPERFECTNUMBER (496) = true
- =ISPERFECTNUMBER (5) = false
- =ISPERFECTNUMBER (0) = false
- =ISPERFECTNUMBER (-6) = false
- =ISPERFECTNUMBER (6) = true
- =ISPERFECTNUMBER (500) = false