DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=If()
|
|
|
=Sum()
|
|
|
=SumIf()
|
|
|
=TrueFalse()
|
Detailed explanation-1: -Answer. The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions. The IF Function will do that, but other functions, like the VLOOKUP, can also return different results depending on the conditions.
Detailed explanation-2: -The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Detailed explanation-3: -The FIND and SEARCH functions are very similar. They both work in the same way-locate a character or a text string in another text string. The difference between these two functions is that FIND is case-sensitive, and SEARCH is not case-sensitive. So if you don’t want to match case in a text string, use SEARCH.