| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''GESTEP'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''num, S)'''</font></font></font> | + | <div style="font-size:30px">'''GESTEP(n,s)'''</div><br/> |
| | + | *<math>n</math> is the number. |
| | + | *<math>s</math> is the step to threshold a value. |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'num' is the value to test against step and 'S' is the threshold value. </font></font></font>
| |
| | | | |
| − | </div> | + | ==Description== |
| − | ----
| + | *This function gives the result in a logical values (0 or 1). |
| − | <div id="7SpaceContent" class="zcontent" align="left"> | + | *It is used to filter the values. |
| | + | *In <math>GESTEP(n,s), n</math> is the number to test against step and <math>s</math> is the step to threshold a value. |
| | + | *Here <math> n </math> value is required and <math> s </math> is optional. |
| | + | *When we are not giving the <math> s </math> value, then it will assumed to be zero. |
| | + | *This function gives the result as 1, <math> n </math> value is greater than or equal to <math> s </math> value, or 0 otherwise. |
| | + | *<math> GESTEP </math> should only be used with numbers. |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">Arguments should be numeric.</font></font></font>
| |
| | | | |
| − | </div>
| + | ==Examples== |
| − | ----
| + | # GESTEP(8,9) = 0 |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| + | # GESTEP(9,8) = 1 |
| | + | # GESTEP(0,1) = 0 |
| | + | # GESTEP(0,0) = 1 |
| | + | # GESTEP(-1,0) = 0 |
| | + | # GESTEP(a,b) = Null |
| | | | |
| − | GESTEP
| |
| | | | |
| − | </div></div>
| + | ==See Also== |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
| |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2">GESTEP(num, S)</font></font></font>
| |
| | | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=GESTEP(3, 2) is 1</nowiki></font></font></font>
| + | ==References== |
| − | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=GESTEP(-3, -3) is 1</nowiki></font></font></font>
| |
| − | | |
| − | <font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=GESTEP(3, 3) is 1</nowiki></font></font></font>
| |
| − | | |
| − | </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="5SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function shows 1, when the number is grater than or equal to the step(threshold value), otherwise it shows zero(0)</font></font></font></div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| id="TABLE1" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | <div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | class=" " | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class="sshl_f" | 1
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class="sshl_f" | 1
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class="sshl_f" | 1
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f SelectTD SelectTD" |
| |
| − | <div id="1Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="1Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | | class="sshl_f" |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |