A logical function, such as the IF function.
The facts.
Not sure what you are asking here, but here is my best guess.COMPUTER PROGRAMMING APPLICATIONS:IF - If a condition exists, do something, if not, do something else.CASE - If a condition equals CASE1 do this; if CASE2 do this; etc.WHILE - If a condition remains, keep doing something until the condition changes.EXCEL:AND(logical1,logical2,...) - tests whether the logical arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to the cell. If any are FALSE, the AND function returns FALSE.IF(logical_test,value_if_true,value_if_false) - tests whether the logical_test expression is TRUE or FALSE. If TRUE, the IF function returns the value_if_true argument. If FALSE, the IF function returns the value_if_false argument.IFERROR(value,value_if_error) - tests whether the value expression is an error. IFERROR returns value_if_error if the expression is an error, or value of the expression if it is not an error.NOT(logical) - tests whether the logical argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. If FALSE, the NOT function returns TRUE.OR(logical1,logical2,...) - tests whether the logical arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.FALSE() - takes no argument and simply enters logical FALSE in its cell.TRUE() - takes no argument and simply enters logical TRUE in its cell.
The IF function.
Condition
The IF function has 3 arguments. They are the condition, the action to take if the condition is true and the action to take if the condition is false. See the related question below.
You insert the second IF function into the first one, creating what is called a nested If. Another IF can be put in the True or False part of an existing IF function. In as situation where there is a need for another IF when the first condition is true, the structure could then be something like this:=IF(condition, IF(condition, true, false), false))Note there are two brackets at the end, closing the two IF functions.
False
The IF function has 3 parameters. The condition, the true part and the false part.
An IF function can be used to do this. It is one of the Logical functions. Others include AND, OR, NOT, FALSE, TRUE and XOR. Using the IF function, we sometimes talk about What-if.
If we consider any function that is not the main function that is declared as "bool" i.e it will return boolean values to the main function-0 & 1, meaning 'false' and 'true' respectively. If we have to tell the main function that the condition checked in the function is false or disagreed, then we return 0 to the main function and when we have to tell that the condition checked in the main function is true or agreed, then we return 1 to the main function.
A condition has to be specified. One or both of the True and False arguments can be left out, though you must place a comma after the condition.
It can be called a logical test.