DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(Logic Test, “Condition met", “Condition not met")
|
|
|
IF(Logic Test, “Condition met", “Condition not met")
|
|
|
=IF(Logic Test, “Condition not met", “Condition met")
|
|
|
all wrong
|
Detailed explanation-1: -A logical test can be a comparison between two cell references such as A2>B1. Or A logical test can be a comparison between a cell reference and a fixed amount such as C7>= 100. A comparative operator will always return a True or False result. Excel recognized True and False Statements as 1 and 0.
Detailed explanation-2: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.
Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK")
Detailed explanation-4: -The NOT Function[1] is an Excel Logical function. The function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, basically, it will always return a reverse logical value.