Respuesta :

Answer:

The answer is "IF and IFERROR".

Explanation:

The conditional logic function is used in excel that use to generate a conditional equation. It is normal to use for many tasks to check whether facts are true or false and to make logical distinctions between words.

This function considers IF and IFTRUE as a conditional logic function. and others are not correct that can be defined as:

  • The NOR and OR is used as a boolean operator functions in excel that return true or false value only.
  • IFTRUE and WHEN is used in programming language. It used as a macro and condition operator.

Condition statements are “IF, IFTRUE, IFERROR".

Explanation:

In programming languages  “IF <Conditon>’” is used. Normally if condition means, if given condition is true either single statement or multiple statement are executed.

With “IF <Conditon>” has “ELSE” or “ELSEIF <Conditonn>”, Else path execution of “IF <CONDITON>” is false.

Same “ELSEIF <CONDITION>” is executed  if “IF CONDITON” is false.

“OR and NOR” is logical operations, “When” is only on sql query mostly.

“IFTRUE” Mostly inbuilt function on some of programming languages, executer if condition is true.

“IFERROR” mostly inbuilt function on some of programming languages, execute if end error comes where assign value is wrong type or variable or identified is not found etc.