DATABASE FUNDAMENTALS
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 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!”).