Difference between revisions of "Manuals/calci/MAXA"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''MAXA'''('''v1''',v2,...) where v1,v2.. are the values. <font color="#484848"><font face="Arial, sans-serif"><fo...")
 
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''MAXA()'''</div><br/>
 +
*Parameters  are any set of numbers.
 +
**MAXA(), returns the maximum value in a list of arguments, including numbers, text, and logical values.
  
−
'''MAXA'''('''v1''',v2,...) where v1,v2.. are the values.
+
== Description ==
 +
MAXA()
 +
*For Example,MAXA(140,5,-2,10) ''returns 140''
 +
*MAXA(-3,0.02,TRUE,-7) ''returns 1''
 +
*Arguments can be numbers, logical values, text, array or references that contain numbers.
 +
*Calci displays zero if the arguments do not have any numbers.
 +
*If the logical values and text values are entered directly in the argument, or as a part of array or reference, are counted in finding the MAX value.
 +
*The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0.
  
−
<font color="#484848"><font face="Arial, sans-serif"><font size="2"></font></font></font></div>
+
==ZOS==
−
----
+
*The syntax is to calculate maximum numbers in the set of numbers in ZOS is <math>MAXA()</math>.
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
**Parameters are any set of numbers.
 +
*For e.g.,MAXA(-10..-1,false)
  
−
MAXA
+
== Examples ==
  
−
</div></div>
+
<div id="2SpaceContent" class="zcontent" align="left"><div>
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></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="4SpaceContent" class="zcontent" align="left"><div>
 
  
 
{| id="TABLE1" class="SpreadSheet blue"
 
{| id="TABLE1" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
| class="sshl_f" | 0.02
−
| class=" " | Column1
+
| class="sshl_f" |  
−
| class="          " | Column2
+
 
−
| class="    " | Column3
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" | 0.5
−
| class="sshl_f " | 2
 
−
| class="sshl_f" | 3
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 +
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
+
| class="sshl_f" | -6
−
| class="sshl_f" | 0.6
 
−
| class="sshl_fSelectTD SelectTD " |
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 +
 
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row3
+
| class="sshl_f" | TRUE
−
| class="sshl_f" | 3
 
−
| class="  " |
 
 
| class="sshl_f" |
 
| class="sshl_f" |
 +
 
|- class="even"
 
|- class="even"
−
| class="sshl_f" | Row4
+
| class="sshl_f" | FALSE
−
| class="sshl_f " | 1
+
| class="sshl_f" |  
−
| class="sshl_f" |
+
 
−
| class="sshl_f" |
 
 
|- class="odd"
 
|- class="odd"
−
| class="sshl_f" | Row5
+
| class="sshl_f" | NAME
−
| class="sshl_f" |
+
| class="sshl_f" |  
−
| class="sshl_f" |
+
 
−
|
 
 
|}
 
|}
  
−
<div align="left"></div>''''''</div></div>
+
=MAXA(A1:A6)  : Calculates the maximum value in the range A1 to A6. Displays ''1'' (for TRUE ) as a result.
−
----
+
=MAXA(-2,FALSE)  : Calculates the maximum value between -2 and FALSE. Displays ''0'' (for FALSE) as a result.
−
<div id="2SpaceContent" class="zcontent" align="left"><font color="#484848"><font face="Arial, sans-serif"><font size="2">
+
=MAXA(A1:A3, 2)  : Calculates the maximum value in the range A1 to A3 and value 2. Displays ''2'' as a result.
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|Wolmo-lcHZ4|280|center|MAXA}}
  
−
'''<font size="3" face="Times New Roman"> </font>'''
+
== See Also ==
  
−
<font size="3"><font face="Times New Roman">Let’s see an example in (Column1 Row 1:Column1Row4)</font></font>
+
*[[Manuals/calci/MAX| MAX]]
  
−
<font size="3">MAXA (v1, v2,….)</font>
+
==References==
  
−
<font size="3">i.e. =MAXA (C1R1:C1R4) is 3.</font>
+
*[http://en.wikipedia.org/wiki/Large_numbers Large Number]
 +
*[http://en.wikipedia.org/wiki/Small_number Small Number]
  
−
</font></font></font></div>
 
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left"><font color="#484848"><font face="Arial, sans-serif"><font size="2"><font color="#000000">  
 
  
−
It calculates  the largest value in a list of arguments.
+
*[[Z_API_Functions | List of Main Z Functions]]
  
−
</font> </font></font></font></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 14:22, 8 August 2018

MAXA()


  • Parameters are any set of numbers.
    • MAXA(), returns the maximum value in a list of arguments, including numbers, text, and logical values.

Description

MAXA()

  • For Example,MAXA(140,5,-2,10) returns 140
  • MAXA(-3,0.02,TRUE,-7) returns 1
  • Arguments can be numbers, logical values, text, array or references that contain numbers.
  • Calci displays zero if the arguments do not have any numbers.
  • If the logical values and text values are entered directly in the argument, or as a part of array or reference, are counted in finding the MAX value.
  • The logical value TRUE is considered '1' and FALSE is considered '0'. Any text is evaluated with value 0.

ZOS

  • The syntax is to calculate maximum numbers in the set of numbers in ZOS is .
    • Parameters are any set of numbers.
  • For e.g.,MAXA(-10..-1,false)

Examples

0.02
0.5
-6
TRUE
FALSE
NAME 
=MAXA(A1:A6)  : Calculates the maximum value in the range A1 to A6. Displays 1 (for TRUE ) as a result.
=MAXA(-2,FALSE)  : Calculates the maximum value between -2 and FALSE. Displays 0 (for FALSE) as a result.
=MAXA(A1:A3, 2)  : Calculates the maximum value in the range A1 to A3 and value 2. Displays 2 as a result.

Related Videos

MAXA

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/MAXA&oldid=210953"