DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IF(logical test; [value if true]; [value if false])
|
|
|
IFELSE(logical test; [value if true]; [value if false])
|
|
|
IF([value if true]; [value if false])
|
|
|
IF([value if true]; [value if false];logical test)
|
Detailed explanation-1: -The syntax for an IF statement is. =IF (Logical Test, [Value if True], [Value if False]). Basic IF statements, IF statements with conditional AND’s or OR’s, and Nested IF statements are all based around this same syntax.
Detailed explanation-2: -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-3: -Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
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.