Difference between revisions of "Manuals/calci/IF"

Revision as of 23:07, 29 January 2014

IF(lt,v1,v2)

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 satisfying 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 a condition.

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 12: / Line 12: @@
 *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.
-*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>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>.
-*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.