Difference between revisions of "Manuals/calci/IF"

Latest revision as of 15:41, 3 August 2018

IF (condition,truepart,falsepart)

$condition$ is the logical test.
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 truepart} and 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 falsepart} are the values.
- IF(), specifies a logical test to perform.

Description

This function gives one value when our specified condition is TRUE and the second value when our specified condition is FALSE.
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 IF } is the Conditional statement and it is used to perform different actions based on different conditions.
In 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 IF (condition,truepart,falsepart)} , 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 condition } is the logical test or expression to evaluate.
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 truepart} is any value or the string and it is displays when the specified 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 condition } is TRUE.
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 falsepart } is any value or the string and it is displays when the specified 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 condition} is FALSE.
For e.g, IF(A2>1000,"costly","cheap"). Here A2>1000 is the logical expression. Costly is the 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 truepart} value and cheap is the 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 falsepart} value.
When our mentioned amount is satisfying the 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 lt} then it shows "costly". Suppose our amount is not satisfying the 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 lt} it shows "cheap".
In CALCI we can give any number of 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 IF} functions can be nested as 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 truepart} and 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 falsepart} statements to give for a complicated tests.
When 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 truepart} and 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 falsepart} are calculated, 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 IF} returns the value returned by 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 truepart} or 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 falsepart} .
If any of the arguments to 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 IF} are arrays, each element of the array is evaluated when the 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 IF} statement is carried out.
We can use COUNTIF and SUMIF functions for more to examine our data based on a condition.

Examples

1.Number=20 IF(A2>=0,"positive","negative") = positive Number=-18 IF(A2>=0,"positive","negative") = negative

2.A1= IF(ISBLANK(A1)=TRUE,"BLANK",IF(ISTEXT(A1)=TRUE,"TEXT",IF(ISNUMBER(A1)=TRUE,"NUM","")))= BLANK

3. A1= winter IF(ISBLANK(A1)=TRUE,"BLANK",IF(ISTEXT(A1)=TRUE,"TEXT",IF(ISNUMBER(A1)=TRUE,"NUM",""))) = TEXT

4. A1=10000 IF(ISBLANK(A1)=TRUE,"BLANK",IF(ISTEXT(A1)=TRUE,"TEXT",IF(ISNUMBER(A1)=TRUE,"NUM","")))=NUM

5.C1=40,D1=90 IF(C1<D1,C1+D1,C1-D1) = 130

References

Logical functions

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''IF(l_t,v1,v2)'''</div><br/>
+<div style="font-size:30px">'''IF (condition,truepart,falsepart)'''</div><br/>
-*<math>l_t</math>is the logical test.
+*<math>condition</math> is the logical test.
-*<math>v1</math> and <math>v1</math> are the values
+*<math>truepart</math> and <math>falsepart</math> are the values.
+**IF(), specifies a logical test to perform.
-==Decription==
+==Description==
 *This function gives one value when our specified condition is TRUE and the second value when our specified condition is FALSE.
 *<math> IF </math> is the Conditional statement and it is  used to perform different actions based on different conditions.
-*In <math> IF(l_t,v1,v2), l_t </math>is the logical test or expression to evaluate.
+*In <math>IF (condition,truepart,falsepart)</math>, <math>condition </math> is the logical test or expression to evaluate.
-*<math> v1 </math> is  any value or the string and it is displays when the specified <math> l_t </math> is TRUE.
+*<math> truepart</math> is any value or the string and it is displays when the specified <math> condition </math> is TRUE.
-*<math> v2 </math>  is  any value or the string and it is displays when the specified l_t is FALSE.
+*<math>falsepart </math> is any value or the string and it is displays when the specified <math>condition</math> is FALSE.
-*For e.g.,IF(A2>1000,"costly","cheap").Here A2>1000 is the logical expression.costly is the v1 value and cheap is the v2 value.
+*For e.g, IF(A2>1000,"costly","cheap"). Here A2>1000 is the logical expression. Costly is the <math>truepart</math> value and cheap is the <math>falsepart</math> value.
-*When our mentioned amount is satifying the l_t then it shows "costly". Suppose our amount is not satifying the l_t it shows "cheap".
+*When our mentioned amount is satisfying the <math> lt</math> then it shows "costly". Suppose our amount is not satisfying the <math>lt</math> it shows "cheap".
-*In CALCI we can give any number of IF functions can be nested as v1 and v2 statements to give for a complicated tests.
+*In CALCI we can give any number of <math>IF</math> functions can be nested as <math>truepart</math> and <math>falsepart</math> statements to give for a complicated tests.
-*When v1 and v2 are calculated, IF returns the value returned by v1 or v2.
+*When <math>truepart</math> and <math>falsepart</math> are calculated, <math>IF</math> returns the value returned by <math>truepart</math> or <math>falsepart</math>.
-*If any of the arguments to IF are arrays,each element of the array is evaluated when the IF statement is carried out.
+*If any of the arguments to <math>IF</math> are arrays, each element of the array is evaluated when the <math>IF</math> statement is carried out.
-*We can use [[[Manuals/calci/COUNTIF  | COUNTIF]]] and [[[Manuals/calci/SUMIF  |SUMIF]]] functions for more to examine our data based on acondition.
+*We can use [[Manuals/calci/COUNTIF  | COUNTIF ]] and [[Manuals/calci/SUMIF  | SUMIF ]] functions for more to examine our data based on a condition.
 ==Examples==
 .Number=20
-IF(A2>=0,"positive","negative") =positive
+IF(A2>=0,"positive","negative") = positive
 Number=-18
-IF(A2>=0,"positive","negative")=negative
+IF(A2>=0,"positive","negative") = negative
 .A1= IF(ISBLANK(A1)=TRUE,"BLANK",IF(ISTEXT(A1)=TRUE,"TEXT",IF(ISNUMBER(A1)=TRUE,"NUM","")))= BLANK
@@ Line 33: / Line 34: @@
 IF(C1<D1,C1+D1,C1-D1) = 130
+==Related Videos==
+{{#ev:youtube|RhuD0l080kg|280|center|IF FUNCTION}}
 ==See Also==
+*[[Manuals/calci/AND| AND]]
+*[[Manuals/calci/OR| OR]]
 ==References==
+*[http://www.excel-easy.com/functions/logical-functions.html Logical functions]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/IF"

Latest revision as of 15:41, 3 August 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search