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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle MAXA()} .
    • 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"