USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Trim
|
|
|
if
|
|
|
Concatenate
|
|
|
Mid
|
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: -=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-3: -The syntax of IF-THEN is =IF(logic test, value if true, value if false). The first argument tells the function what to do if the comparison is true. The second argument tells the function what to do if the comparison is false.
Detailed explanation-4: -The simplest IF() function may be written with the first two parameters only. For example, this formula is absolutely correct: =IF(C2=1, "Hello!") This formula tests the condition we set (C2=1) and if it is true, the formula returns the text message (“Hello!”).