Question

The ___________ function is used to check a condition.

Answer 1

The IF-ELSE function is used to check a condition.

Explanation:

• Conditional programming is done for decision based problems.

• IF-ELSE is a conditional function which is used when different conditions need to be tested or checked.

• IF evaluates the expression given as condition and performs the action when the condition is true. When the condition is untrue, the action under IF is not performed and the action under ELSE is performed.

Syntax:

if (condition)

{

//action to be performed

}

else

{

//different action to be performed

}

Answer 2

A conditional function not only checks the condition but logic as well.  

Explanation:

It also checks the increment values, cases, and continuity. It is a built-in operator that checks whether an expression is true or false.  

In excel, the conditional function is:

=IF( )

• We can specify a value in the function to check or test something.
• We can also specify whether the results will be true or false.