# Manuals/calci/IF

Jump to navigation
Jump to search

Syntax

Examples-1

**'''''''**

**''''**Description

IF is used to conduct conditional tests on values and formulas.

IF

**IF**(**L****og Test**,**V If true**,**v If false**)

**where Log Test** is any value or expression that can be evaluated to TRUE or FALSE and **V** **If true** is the value that is returned if logical_test is TRUE and **V** **If false** is the value that is returned if logical_test is FALSE.

Column1 | Column2 | Column3 | Column4 | |

Row1 | 8 | Alkaline | ||

Row2 | ||||

Row3 | ||||

Row4 | ||||

Row5 | ||||

Row6 |

Examples-2

Column1 | Column2 | Column3 | Column4 | |

Row1 | 40 | P | ||

Row2 | 85 | A | ||

Row3 | 66 | |||

Row4 | ||||

Row5 | ||||

Row6 |

Column1 | Column2 | Column3 | Column4 | |

Row1 | 1000 | 1500 | Negative | |

Row2 | 900 | 900 | ||

Row3 | 650 | 1000 | ||

Row4 | ||||

Row5 | ||||

Row6 |

Let's see an example in Column1Row1

B1 = 8

I.e.=IF(B1<7,”Acid”,”Alkaline”) is Alkaline

Examples-3

Assets Liabilities

B1= 1000 C1 =1500

B2 =900 C2=900

B3 = 650 C3 = 1000

I.e = IF(B1<C2,”negative equity”,”plus”) is negative equity

B1 = 40

B2 = 85

B3 =66

I.e =IF(B1>80,”A”,IF(B1>60,”B”,IF(B1>30,”P”))) is P

///rly =IF(B2>80,”A”,IF(B2>60,”B”,IF(B2>30,”P”))) is A