Manuals/calci/IF
Syntax
Examples-1
''''''' ''''
Description
IF is used to conduct conditional tests on values and formulas.
IF
IF(Log 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