USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(value if true;value if false)
|
|
|
=IF(logical test;value if true)
|
|
|
=IF(logical test;value if false)
|
|
|
=IF(logical test)
|
|
|
=IF(logical test;value if true;value if false)
|
Detailed explanation-1: -Syntax. 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-2: -Top Answer b )Explanation: IN MS Excel, “IF” function is used to check the particular condition. It will return differently depending on the result of the condition was TRUE or FALSE. Thus, option (b) is correct.
Detailed explanation-3: -=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. Value if true (optional argument) – The value that will be returned if the logical test evaluates to TRUE.
Detailed explanation-4: -The syntax for an IF statement is. =IF (Logical Test, [Value if True], [Value if False]). Basic IF statements, IF statements with conditional AND’s or OR’s, and Nested IF statements are all based around this same syntax.