DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(AND(C4>4, D4>3), “Counseling", “")
|
|
|
=IF(A1=10, “Correct", “Wrong")
|
|
|
=IF(OR(C3>2<4, D3<3), “Verbal Warning", “")
|
|
|
=IF(D2>89, “A", IF(D2>79, “B", “F"))
|
Detailed explanation-1: -Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes. We want to determine a student’s grade based on their score. If Bob’s score in B2 is greater than or equal to 90, return an A.
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: -Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function.
Detailed explanation-4: -Nested IF in Excel with OR statements By using the OR function you can check two or more different conditions in the logical test of each IF function and return TRUE if any (at least one) of the OR arguments evaluates to TRUE.