USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
SUMIF
|
|
COUNTIF
|
|
IF
|
|
AVERAGEIF
|
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")
Detailed explanation-2: -The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition.
Detailed explanation-3: -IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE.
Detailed explanation-4: -Technically, the AND function tests the conditions you specify and returns TRUE if all of the conditions evaluate to TRUE, FALSE otherwise.
Detailed explanation-5: -Consequently, in the logical test of your IF formula, you should use one of these functions: AND function-returns TRUE if all the conditions are met; FALSE otherwise. OR function-returns TRUE if any single condition is met; FALSE otherwise.