USING MICROSOFT EXCEL
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: -IF is one of the Logical functions in Microsoft Excel, and there are 3 parts (arguments) to the IF function syntax: logical test: TEST something, such as the value in a cell. value if true: Specify what should happen if the test result is TRUE. value if false: Specify what should happen if the test result is FALSE.
Detailed explanation-4: -Yes, you can combine SUMIF and IF statements. This combination can be used to add up values in a range of cells based on specific criteria. For example, you can use a SUMIF and IF statement to add up the values in a range of cells if those cells meet a certain condition.