Manuals/calci/IF

Revision as of 00:03, 30 January 2014 by Abin (talk | contribs) (→‎Decription)
IF(lt,v1,v2)


  • is the logical test.
  • and 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.
  •   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   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 satisfying 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 a condition.

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


See Also

References