Difference between revisions of "Manuals/calci/IF"

Revision as of 03:22, 10 January 2014

IF(lt,v_1,v_2)

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

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

@@ Line 10: / Line 10: @@
 *<math> v_2 </math>  is  any value or the string and it is displays when the specified lt 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.
-*When our mentioned amount is satifying the lt then it shows "costly".  Suppose our amount is not satifying the lt it shows "cheap".
+*When our mentioned amount is satisfying the <math> lt</math> then it shows "costly".  Suppose our amount is not satifying the <math>lt</math> it shows "cheap".
-*In CALCI we can give any number of IF 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>v_1</math> and <math>v_2</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>.
 *If any of the arguments to IF are arrays,each element of the array is evaluated when the IF statement is carried out.