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

Jump to navigation
Jump to search

Line 1: | Line 1: | ||

− | <div style="font-size:30px">'''IF( | + | <div style="font-size:30px">'''IF(lt,v_1,v_2)'''</div><br/> |

− | *<math> | + | *<math>lt</math>is the logical test. |

− | *<math> | + | *<math>v_1</math> and <math>v_2</math> are the values |

==Decription== | ==Decription== | ||

*This function gives one value when our specified condition is TRUE and the second value when our specified condition is FALSE. | *This function gives one value when our specified condition is TRUE and the second value when our specified condition is FALSE. | ||

*<math> IF </math> is the Conditional statement and it is used to perform different actions based on different conditions. | *<math> IF </math> is the Conditional statement and it is used to perform different actions based on different conditions. | ||

− | *In <math> IF( | + | *In <math> IF(lt,v_1,v_2), lt </math>is the logical test or expression to evaluate. |

− | *<math> | + | *<math> v_1 </math> is any value or the string and it is displays when the specified <math> lt </math> is TRUE. |

− | *<math> | + | *<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 | + | *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 satifying the | + | *When our mentioned amount is satifying the lt then it shows "costly". Suppose our amount is not satifying the lt it shows "cheap". |

− | *In CALCI we can give any number of IF functions can be nested as | + | *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. |

− | *When | + | *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. | ||

− | *We can use [[[Manuals/calci/COUNTIF | COUNTIF]]] and [[[Manuals/calci/SUMIF |SUMIF]]] functions for more to examine our data based on acondition. | + | *We can use [[[[[Manuals/calci/COUNTIF | COUNTIF]]]]] and [[[[[Manuals/calci/SUMIF |SUMIF]]]]] functions for more to examine our data based on acondition. |

==Examples== | ==Examples== |

## Revision as of 04:23, 9 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 satifying the lt then it shows "costly". Suppose our amount is not satifying the lt it shows "cheap".
- In CALCI we can give any number of IF 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 [[[[[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