Difference between revisions of "Manuals/calci/IF"

Latest revision as of 16:41, 3 August 2018

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.
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 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 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(lt,v1,v2)'''</div><br/>
+<div style="font-size:30px">'''IF (condition,truepart,falsepart)'''</div><br/>
-*<math>lt</math> is the logical test.
+*<math>condition</math> is the logical test.
-*<math>v_1</math> and <math>v_2</math> are the values
+*<math>truepart</math> and <math>falsepart</math> 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.
 *<math> IF </math> is the Conditional statement and it is  used to perform different actions based on different conditions.
-*In <math> IF(lt,v_1,v_2)</math>, <math>lt </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> v_1 </math> is any value or the string and it is displays when the specified <math> lt </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> v_2 </math> is any value or the string and it is displays when the specified <math>lt</math> 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 <math>v_1</math> value and cheap is the <math>v_2</math> 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 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 <math>IF</math> functions can be nested as <math>v_1</math> and <math>v_2</math> 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 <math>v_1</math> and <math>v_2</math> are calculated, IF returns the value returned by <math>v_1</math> or <math>v_2</math>.
+*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 a condition.
@@ Line 32: / Line 33: @@
 .C1=40,D1=90
 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 ]]