DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which includes the formula for IF that is correctly written is ____
|
|
IF(Comparison;Value if true, Value if false)
|
|
|
=IF(Comparison;Value if true;Value if false)
|
|
|
=IF(Comparison, Value if true:Value if false)
|
|
|
=IF[Comparison;Value if true;Value if false]
|
|
|
IF (SUM:AVERAGE)
|
Explanation:
Detailed explanation-1: -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") =IF(A2=B2, B4-A4, "")
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: -The FALSE function in Excel is equivalent to the number 0.
Detailed explanation-4: -The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
There is 1 question to complete.