# Difference between revisions of "Manuals/calci/IF"

IF (condition,truepart,falsepart)

• is the logical test.
• and are the values.
• IF(), specifies a logical test to perform.

## 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, returns the value returned by or .
• If any of the arguments to are arrays, each element of the array is evaluated when the 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

IF FUNCTION