Difference between revisions of "Manuals/calci/MAXIF"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''AVEDEV(n1,n2,n3...)'''</div><br/> *<math>n_1,n_2,n_3...</math> are any real numbers.") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">''' | + | <div style="font-size:30px">'''MAXIF (Array,Condition,SumArray)'''</div><br/> |
| − | *<math> | + | *<math>Array</math> is the set of values. |
| + | *<math>Condition</math> is the particular condition value. | ||
| + | |||
| + | ==Description== | ||
| + | *This function shows the maximum value with in the given set. | ||
| + | *In <math>MAXIF(Array,Condition,SumArray)</math>, <math>Array</math> is the set of values. | ||
| + | *<math>Condition</math> is special condition which is for given array.Maximum value is the largest value in the set of values. | ||
| + | *So this function returns the any one maximum value which satisfies the specified condition. | ||
| + | *<math>Array</math> value can be numbers, logical values, text, array or references that contain 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. | ||
| + | *This function will return the result as error when any one of the argument is non-numeric or the referred array cannot translated in to numbers. | ||
| + | *suppose we want to consider the logical values in a referred array , we can include in the [[Manuals/calci/MAXA | MAXA ]] function. | ||
| + | |||
| + | |||
| + | ==Examples== | ||
| + | #MAXIF([12,87,13,10,9,13],">10") = 87 | ||
| + | #MAXIF([15,19,20,25,27,32],"<20") = 19 | ||
| + | #MAXIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],"<1.06") = 1.02 | ||
| + | #MAXIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],">1.06") = 2.3 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=VCHH3ux1ybk|280|center|MaxIf}} | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/MAX| MAX]] | ||
| + | *[[Manuals/calci/MAXA| MAXA]] | ||
| + | *[[Manuals/calci/MIN| MIN]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Large_numbers Large Number] | ||
| + | *[http://en.wikipedia.org/wiki/Small_number Small Number] | ||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 15:42, 29 November 2018
MAXIF (Array,Condition,SumArray)
- is the set of values.
- is the particular condition value.
is the set of values.
is the particular condition value.Description
- This function shows the maximum value with in the given set.
- In , is the set of values.
- is special condition which is for given array.Maximum value is the largest value in the set of values.
- So this function returns the any one maximum value which satisfies the specified condition.
- value can be numbers, logical values, text, array or references that contain 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.
- This function will return the result as error when any one of the argument is non-numeric or the referred array cannot translated in to numbers.
- suppose we want to consider the logical values in a referred array , we can include in the MAXA function.
,
Examples
- MAXIF([12,87,13,10,9,13],">10") = 87
- MAXIF([15,19,20,25,27,32],"<20") = 19
- MAXIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],"<1.06") = 1.02
- MAXIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],">1.06") = 2.3