Here’s how to use if statment.
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.
Parameter:
|
x |
A Boolean expression |
Example:
|
|
A |
B |
|
|
1 |
=6 |
|
16 |
|
2 |
if A1>5 |
|
if code block |
|
3 |
|
>A1=A1+10 |
Related function:
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.
Parameter:
|
x |
A Boolean expression |
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 function:
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.
Parameter:
|
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:
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.
Parameter:
|
x |
A Boolean expression |
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 |