DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(A1="M", “MARRIED", IF(A1="S", “SINGLE"))
|
|
|
=IF(A1=M, “MARRIED", “SINGLE")
|
|
|
=IF(A1="M", “MARRIED", “S", “SINGLE"))
|
|
|
=IF(A1="M", “MARRIED", “SINGLE")
|
Detailed explanation-1: -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-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: -For example, the formula =SUMIF(B2:B5, “John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John.” To sum cells based on multiple criteria, see SUMIFS function.
Detailed explanation-4: -The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.