Difference between revisions of "Manuals/calci/ISNUMBER"

Latest revision as of 15:50, 2 July 2018

ISNUMBER(Number)

is any number.
- ISNUMBER(),Returns TRUE if the value is a number.

Description

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.

ZOS

The syntax is to find whether the given data is a number in ZOS is .
- is any number.
For e.g.,ISNUMBER(log(20)),ISNUMBER(SUM(10,20,30,40,50))

Examples

=ISNUMBER(2) = TRUE
=ISNUMBER(0) = TRUE
=ISNUMBER(-100) = TRUE
=ISNUMBER(y) = NULL
=ISNUMBER($) = FALSE
=ISNUMBER("17") = TRUE

References

Is functions

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+<div style="font-size:30px">'''ISNUMBER(Number)'''</div><br/>
+*<math>Number</math> is any number.
+**ISNUMBER(),Returns TRUE if the value is a number.
-'''ISNUMBER'''(Value)
+==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.
-where,
+==ZOS==
+*The syntax is to find whether the given data is a number in ZOS is <math>ISNUMBER(Number)</math>.
+**<math>Number</math> is any number.
+*For e.g.,ISNUMBER(log(20)),ISNUMBER(SUM(10,20,30,40,50))
-'''Value''' -  represents the value in cell.
+==Examples==
+#=ISNUMBER(2) = TRUE
+#=ISNUMBER(0) = TRUE
+#=ISNUMBER(-100) = TRUE
+#=ISNUMBER(y) = NULL
+#=ISNUMBER($) = FALSE
+#=ISNUMBER("17") = TRUE
-</div>
+==Related Videos==
-----
-<div id="1SpaceContent" class="zcontent" align="left">
-If cell having value is number, ISNUMBER returns 1.
+{{#ev:youtube|oD0srLcl3vo|280|center|ISNUMBER}}
-</div>
+==See Also==
-----
+*[[Manuals/calci/ISLOGICAL  | ISLOGICAL ]]
-<div id="7SpaceContent" class="zcontent" align="left">
+*[[Manuals/calci/ISODD  | ISODD ]]
+*[[Manuals/calci/ISEVEN  | ISEVEN ]]
-</div>
+==References==
-----
+[http://en.wikipedia.org/wiki/Is_functions Is functions]
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-ISNUMBER
-</div></div>
-----
-<div id="8SpaceContent" class="zcontent" align="left">
-Lets see an example in (Column1, Row2)
+*[[Z_API_Functions | List of Main Z Functions]]
-<nowiki>=ISNUMBER(R1C1)</nowiki>
+*[[ Z3 |   Z3 home ]]
-ISNUMBER returns 1.
-Cosider an another example
-<nowiki>=ISNUMBER(C1)</nowiki>
-It returns 0.
-</div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
-----
-<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
-<div id="2SpaceContent" class="zcontent" align="left">
-{| id="TABLE3" class="SpreadSheet blue"
-|- class="even"
-| class=" " |
-| class="   " | Column1
-| class="  " | Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="  " | 5
-| class="sshl_f" | 0
-| 0
-| 0
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" | 1
-| class="sshl_f" | 0
-| 0
-| 0
-|- class="odd"
-| Row3
-| 0
-| class="       SelectTD ChangeBGColor SelectTD" |
-<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
-| 0
-| 0
-|- class="even"
-| Row4
-| 0
-| 0
-| 0
-| 0
-|- class="odd"
-| class=" " | Row5
-| 0
-| 0
-| 0
-| 0
-|- class="even"
-| Row6
-| 0
-| 0
-| 0
-| 0
-|}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----