FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which is the correct way to write this function:IF C3 is equal to 70, show “Pass", otherwise, show “Fail”
A
=IF C3=70, “Pass", “Fail”
B
=IF(C3=70, “Fail", “Pass")
C
=IF(C3=70, Fail, Pass)
D
=IF(C3=70, “Pass", “Fail")
Explanation: 

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: -Using the setup in Unais’ screenshot: =IF(AND(COUNTIF($B2:$D2, ">=50")=3, COUNTIF($E2:$G2, ">=50")>0), "Pass", "Fail") or more of the same =IF(COUNTIF($B2:$D2, ">=50")/3+COUNTIF($E2:$G2, ">=50")/1>=2, "Pass", "Fail") .

Detailed explanation-3: -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.

There is 1 question to complete.
Previous
Next