DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IF(B4>200, “High", “Low")
|
|
|
=IF(B4<200, “High", “Low")
|
|
|
=IF(B4>200, “High", “Low")
|
|
|
=IF(B4>200"High", “")
|
Detailed explanation-1: -Syntax. 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: -Another way to get an Excel IF to test multiple conditions is by using an array formula. To complete an array formula correctly, press the Ctrl + Shift + Enter keys together. In Excel 365 and Excel 2021, this also works as a regular formula due to support for dynamic arrays.
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.