Manuals/calci/IF

IF(l_t,v1,v2)

• $l_{t}$is the logical test.
• $v1$ and $v1$ 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.
• $IF$ is the Conditional statement and it is used to perform different actions based on different conditions.
• In $IF(l_{t},v1,v2),l_{t}$is the logical test or expression to evaluate.
• $v1$ is any value or the string and it is displays when the specified $l_{t}$ is TRUE.
• $v2$ is any value or the string and it is displays when the specified l_t is FALSE.
• For e.g.,IF(A2>1000,"costly","cheap").Here A2>1000 is the logical expression.costly is the v1 value and cheap is the v2 value.
• When our mentioned amount is satifying the l_t then it shows "costly". Suppose our amount is not satifying the l_t it shows "cheap".
• In CALCI we can give any number of IF functions can be nested as v1 and v2 statements to give for a complicated tests.
• When v1 and v2 are calculated, IF returns the value returned by v1 or v2.
• 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 [[[Manuals/calci/COUNTIF | COUNTIF]]] and [[[Manuals/calci/SUMIF |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