Manuals/calci/IF - Revision history

Devika at 21:41, 3 August 2018

2018-08-03T21:41:01Z

Devika at 21:39, 3 August 2018

2018-08-03T21:39:46Z

Devika at 21:39, 3 August 2018

2018-08-03T21:39:10Z

Jayaram at 11:22, 14 March 2017

2017-03-14T11:22:56Z

Swapna at 19:31, 24 June 2015

2015-06-24T19:31:46Z

Devika at 19:08, 13 May 2015

2015-05-13T19:08:19Z

Abin: /* Description */

2014-01-30T05:07:26Z

Description

Abin: /* Examples */

2014-01-30T05:04:36Z

Examples

Abin: /* Decription */

2014-01-30T05:03:25Z

Decription

Abin at 06:04, 15 January 2014

2014-01-15T06:04:57Z

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''IF (condition,truepart,falsepart)'''</div><br/>
 *<math>condition</math> is the logical test.
-*<math>truepart</math> and <math>falsepart</math> are the values
+*<math>truepart</math> and <math>falsepart</math> are the values.
 ==Description==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''IF(lt,v1,v2)IF (condition,truepart,falsepart)'''</div><br/>
+<div style="font-size:30px">'''IF (condition,truepart,falsepart)'''</div><br/>
 *<math>condition</math> is the logical test.
 *<math>truepart</math> and <math>falsepart</math> are the values

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''IF(lt,v1,v2)'''</div><br/>
+<div style="font-size:30px">'''IF(lt,v1,v2)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
 ==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, <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.
 *We can use [[Manuals/calci/COUNTIF  | COUNTIF ]] and [[Manuals/calci/SUMIF  | SUMIF ]] functions for more to examine our data based on a condition.

← Older revision		Revision as of 11:22, 14 March 2017
Line 43:		Line 43:
	==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 ]]

@@ Line 32: / Line 32: @@
 .C1=40,D1=90
 IF(C1<D1,C1+D1,C1-D1) = 130
 ==See Also==

← Older revision		Revision as of 19:08, 13 May 2015
Line 34:		Line 34:

	==See Also==		==See Also==
		+	*[[Manuals/calci/AND\| AND]]
		+	*[[Manuals/calci/OR\| OR]]

	==References==		==References==
		+	*[http://www.excel-easy.com/functions/logical-functions.html Logical functions]

@@ Line 18: / Line 18: @@
 ==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 32: / Line 32: @@
 .C1=40,D1=90
 IF(C1<D1,C1+D1,C1-D1) = 130
 ==See Also==
 ==References==