# Manuals/calci/IF

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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