http://wiki.zcubes.com/index.php?action=history&feed=atom&title=Manuals%2Fcalci%2FLOWER1 2026-06-25T16:37:48Z Revision history for this page on the wiki MediaWiki 1.35.2 http://wiki.zcubes.com/index.php?title=Manuals/calci/LOWER1&diff=486&oldid=prev 2013-10-25T02:39:32Z

<p>Created page with &quot;&lt;div id=&quot;6SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt; LOWER(text) where text- is the text that converted into lowercase. &lt;/div&gt; ---- &lt;div id=&quot;1SpaceContent&quot; class=...&quot;</p> <p><b>New page</b></p><div>&lt;div id=&quot;6SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> LOWER(text)<br /> <br /> where text- is the text that converted into lowercase.<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;1SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> Calci converts all uppercase letters into lowercase letters.<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;7SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> LOWER ignores the characters in text that are not letters.<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;12SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;left&quot;&gt;<br /> <br /> LOWER<br /> <br /> &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;8SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> Lets see an example in (Column2,Row1)<br /> <br /> &lt;nowiki&gt;=LOWER(B2)&lt;/nowiki&gt;<br /> <br /> LOWER returns smith.<br /> <br /> Consider another example<br /> <br /> &lt;nowiki&gt;=LOWER(&quot;Zcubes&quot;)&lt;/nowiki&gt;<br /> <br /> LOWER converted Zcubes into zcubes.<br /> <br /> &lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;10SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Syntax &lt;/div&gt;&lt;div class=&quot;ZEditBox&quot;&gt;&lt;center&gt;&lt;/center&gt;&lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;4SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Remarks &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;3SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Examples &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;11SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;&lt;div class=&quot;ZEditBox&quot; align=&quot;justify&quot;&gt;Description &lt;/div&gt;&lt;/div&gt;<br /> ----<br /> &lt;div id=&quot;2SpaceContent&quot; class=&quot;zcontent&quot; align=&quot;left&quot;&gt;<br /> <br /> {| id=&quot;TABLE3&quot; class=&quot;SpreadSheet blue&quot;<br /> |- class=&quot;even&quot;<br /> | class=&quot; &quot; |<br /> | Column1<br /> | Column2<br /> | Column3<br /> | Column4<br /> |- class=&quot;odd&quot;<br /> | class=&quot; &quot; | Row1<br /> | class=&quot; &quot; | SMITH<br /> | class=&quot;sshl_f&quot; | smith<br /> | 4<br /> | class=&quot;sshl_f&quot; | 5<br /> |- class=&quot;even&quot;<br /> | class=&quot; &quot; | Row2<br /> | class=&quot; &quot; | 7<br /> | class=&quot;sshl_f &quot; | 8<br /> | 9<br /> | class=&quot;sshl_f&quot; | 128<br /> |- class=&quot;odd&quot;<br /> | Row3<br /> | class=&quot; &quot; | 12<br /> | class=&quot;sshl_f&quot; | 67968<br /> | 14<br /> | class=&quot;sshl_f &quot; | 15<br /> |- class=&quot;even&quot;<br /> | Row4<br /> | 17<br /> | class=&quot; &quot; | 18<br /> | class=&quot;sshl_f&quot; | 10000<br /> | class=&quot; &quot; | 20<br /> |- class=&quot;odd&quot;<br /> | class=&quot; &quot; | Row5<br /> | 36<br /> | 67994<br /> | 10027<br /> | 168<br /> |- class=&quot;even&quot;<br /> | Row6<br /> | NaN<br /> | 0.8509<br /> | 1.6198<br /> | 0.5253<br /> |}<br /> <br /> &lt;div align=&quot;left&quot;&gt;&lt;/div&gt;''''''&lt;/div&gt;<br /> ----</div>

MassBot1