if

Read(278) Label: if,

Here’s how to use if statment.

if x

Description:

The introduction of if statement.

Syntax:

if x

Note:

The statement executes the if code block if x is true and skip if code block if x is false.

Parameters:

x

A boolean expression. If the value is true, then execute if code block. Otherwise, skip it.

Example:

 

A

B

 

1

=6

 

16

2

if A1>5

 

if code block

3

 

>A1=A1+10

Related functions:

if x …{ else { if x} }

if x … else

if x else

if x …{ else { if x }… }

Description:

The introduction of if statement.

Syntax:

if  x 

      The if code block

{else {if x}}

  The else or else if code block. When else or else if is not found, then else or else if code block does not exist.

Note:

If the conditional expression x is evaluated as true, then execute the if code block, otherwise, skip the if code block and execute the code block of else or else if.

Parameters:

x

A boolean expression. If the result is true, then execute if code block, otherwise, execute the else or else if code block, if any. If no else or else if code block is available, then the if statement terminates.

Example:

 

A

B

C

 

1

=13

=2

 

C1 returns 7

2

if(A1>10)

 

 

 

3

 

if(B1==1)

>C1=2+3

 

4

 

else if(B1==2)

>C1=3+4

 

5

 

else if(B1==3)

>C1=4+5

 

6

else if(A1>5)

 

 

 

7

 

>C1=5+6

 

 

Related functions:

if x … else

if x else

if x

if x …else …

Description:

The introduction of if statement.

Syntax:

if  x   else

Note:

if and else are in the same line. If x is true, then execute the code between if and else; if x is false, execute the code after else till the end of this line. The else… part can be omitted.

Parameters:

x

A boolean expression

Example:

 

A

B

C

D

 

1

=2

 

 

 

A1 returns 7

2

if A1>5

>A1=A1+4

else

>A1=A1+5

 

Related functions:

if x …{ else { if x}… }

if x else

if x

 

if x else

Description:

The introduction of if statement.

Syntax:

if  x

 

else

   

Note:

if and else must be in the same column. Execute if code block if x is true and execute else code block if x is false. The else part can be omitted.

Parameters:

x

A boolean expression. If evaluated to be true, then execute if code block, otherwise, execute else code block.

Example:

 

A

B

 

1

=3

 

 

2

if A1>5

 

if code block

3

 

>A1=A1+10

4

else

 

else code block

5

 

>A1=A1+15

Related functions:

if x …{ else { if x}… }

if x … else

if x