Difference between revisions of "Manuals/calci/IF"
Jump to navigation
Jump to search
Line 10: | Line 10: | ||
*<math> v_2 </math> is any value or the string and it is displays when the specified lt is FALSE. | *<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. | *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 | + | *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>. | *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. | *If any of the arguments to IF are arrays,each element of the array is evaluated when the IF statement is carried out. |
Revision as of 02:22, 10 January 2014
IF(lt,v_1,v_2)
- is the logical test.
- and are the values
Decription
- 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 lt is FALSE.
- For e.g.,IF(A2>1000,"costly","cheap").Here A2>1000 is the logical expression. Costly is the value and cheap is the value.
- When our mentioned amount is satisfying the then it shows "costly". Suppose our amount is not satifying the it shows "cheap".
- In CALCI we can give any number of functions can be nested as and statements to give for a complicated tests.
- When and are calculated, IF returns the value returned by or .
- 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.
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