Difference between revisions of "Manuals/calci/ISNUMBER"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ISNUMBER'''(Value) where, '''Value''' - represents the value in cell. </div> ---- <div id="1SpaceCon...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''ISNUMBER(n)'''</div><br/> |
| + | *<math>n</math> is the number | ||
| − | + | ==Description== | |
| + | *This function is one of the group in <math> ISFUNCTIONS</math>. | ||
| + | *The <math>IS FUNCTION</math> is also known as data information functions, data inspection functions or data-testing functions. | ||
| + | *<math>ISNUMBER</math> is used to test given value is number or not. | ||
| + | *This function gives the result as TRUE when the given value is the number otherwise this function gives th result as FALSE. | ||
| + | *This function will not convert any numbers from text. | ||
| + | *For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number. | ||
| − | + | ==Examples== | |
| + | #ISNUMBER(2)=TRUE | ||
| + | #ISNUMBER(0)=TRUE | ||
| + | #ISNUMBER(-100)=TRUE | ||
| + | #ISNUMBER(y)=NULL | ||
| + | #ISNUMBER($)=FALSE | ||
| + | #ISNUMBER("17")=TRUE | ||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/ISNUMBER | ISNUMBER ]] | ||
| + | *[[Manuals/calci/ISODD | ISODD ]] | ||
| + | *[[Manuals/calci/ISEVEN | ISEVEN ]] | ||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 05:24, 20 December 2013
ISNUMBER(n)
- is the number
is the numberDescription
- This function is one of the group in .
- The is also known as data information functions, data inspection functions or data-testing functions.
- is used to test given value is number or not.
- This function gives the result as TRUE when the given value is the number otherwise this function gives th result as FALSE.
- This function will not convert any numbers from text.
- For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.
.
is also known as data information functions, data inspection functions or data-testing functions.
is used to test given value is number or not.Examples
- ISNUMBER(2)=TRUE
- ISNUMBER(0)=TRUE
- ISNUMBER(-100)=TRUE
- ISNUMBER(y)=NULL
- ISNUMBER($)=FALSE
- ISNUMBER("17")=TRUE