Difference between revisions of "Manuals/calci/IF"

From ZCubes Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by 2 users not shown)
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==
 
==Description==
 
*This function gives one value when our specified condition is TRUE and the second value when our specified condition is FALSE.
 
*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.
 
*<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".
 
*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, <math>IF</math> 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 <math>IF</math> are arrays, each element of the array is evaluated when the <math>IF</math> 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.
 
*We can use [[Manuals/calci/COUNTIF  | COUNTIF ]] and [[Manuals/calci/SUMIF  | SUMIF ]] functions for more to examine our data based on a condition.
Line 43: Line 44:
 
==References==
 
==References==
 
*[http://www.excel-easy.com/functions/logical-functions.html Logical functions]
 
*[http://www.excel-easy.com/functions/logical-functions.html Logical functions]
 +
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 16:41, 3 August 2018

IF (condition,truepart,falsepart)


  • is the logical test.
  • and 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.
  • is the Conditional statement and it is used to perform different actions based on different conditions.
  • In , is the logical test or expression to evaluate.
  • is any value or the string and it is displays when the specified is TRUE.
  • is any value or the string and it is displays when the specified 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 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

Related Videos

IF FUNCTION

See Also

References



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