http://wiki.zcubes.com/index.php?action=history&feed=atom&title=Manuals%2Fcalci%2FMAXA1
Manuals/calci/MAXA1 - Revision history
2026-06-25T14:52:13Z
Revision history for this page on the wiki
MediaWiki 1.35.2
http://wiki.zcubes.com/index.php?title=Manuals/calci/MAXA1&diff=492&oldid=prev
MassBot1: Created page with "<div id="6SpaceContent" class="zcontent" align="left"> MAXA(n1,n2,n3.........) MAXA(R1,R2,external R1............) There is no limit to how many parameters pass to MA..."
2013-10-25T02:39:48Z
<p>Created page with "<div id="6SpaceContent" class="zcontent" align="left"> MAXA(n1,n2,n3.........) MAXA(R1,R2,external R1............) There is no limit to how many parameters pass to MA..."</p>
<p><b>New page</b></p><div><div id="6SpaceContent" class="zcontent" align="left"><br />
<br />
MAXA(n1,n2,n3.........)<br />
<br />
MAXA(R1,R2,external R1............)<br />
<br />
There is no limit to how many parameters pass to MAXA.<br />
<br />
</div><br />
----<br />
<div id="1SpaceContent" class="zcontent" align="left"><br />
<br />
This function calculates the largest value from set of numbers.<br />
<br />
</div><br />
----<br />
<div id="7SpaceContent" class="zcontent" align="left"><br />
<br />
Parameters can be numbers,array,logical values<br />
<br />
TRUE counted as 1 and FALSE counted as 0<br />
<br />
Parameters have no numbers, MAXA shows 0.<br />
<br />
</div><br />
----<br />
<div id="9SpaceContent" class="zcontent" align="left"><br />
<br />
{| id="TABLE3" class="SpreadSheet blue"<br />
|- class="even"<br />
| class=" " |<br />
| Column1<br />
| Column2<br />
| Column3<br />
| class=" " | Column4<br />
|- class="odd"<br />
| class=" " | Row1<br />
| class=" " | 2<br />
| class="sshl_f " | 17<br />
| class=" " | 0.1<br />
| class="sshl_f" | 1<br />
|- class="even"<br />
| class=" " | Row2<br />
| class=" " | 7<br />
| class=" sshl_f " |<br />
| class=" " | 0.5<br />
| class="SelectTD" |<br />
|- class="odd"<br />
| Row3<br />
| class="sshl_f" | FALSE<br />
|<br />
| class=" " | TRUE<br />
|<br />
|- class="even"<br />
| Row4<br />
| class=" " | 17<br />
|<br />
| class=" " | 0.8<br />
|<br />
|- class="odd"<br />
| class=" " | Row5<br />
| class=" " |<br />
|<br />
| class="sshl_f " | 0.9<br />
|<br />
|- class="even"<br />
| Row6<br />
|<br />
|<br />
| class="sshl_f" |<br />
|<br />
|}<br />
<br />
<div align="left"></div>''''''</div><br />
----<br />
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"><br />
<br />
MAXA<br />
<br />
</div></div><br />
----<br />
<div id="8SpaceContent" class="zcontent" align="left"><br />
<br />
Lets see an example in (Column3,Row1)<br />
<br />
<nowiki>=MAXA(B2:B5)</nowiki><br />
<br />
Largest number from (2,7,FALSE,17) is 17.<br />
<br />
Consider another example<br />
<br />
<nowiki>=MAXA(0.1,0.5,TRUE,0.8,0.9)</nowiki><br />
<br />
MAXA return the smallest number from(0.1,0.5,TRUE,0.8,0.9)<br />
<br />
is 1.<br />
<br />
</div><br />
----<br />
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div><br />
----<br />
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div><br />
----<br />
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div><br />
----<br />
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div><br />
----</div>
MassBot1