FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Note the following excerpt of the IF function: =IF(A2="L", “Male", “Female") If the content of A2 is A, then the result of the function is ____
A
Man
B
Woman
C
Salah
D
Right
E
There isn’t any
Explanation: 

Detailed explanation-1: -How to use IF function with multiple conditions. In essence, there are two types of the IF formula with multiple criteria based on the AND / OR logic. Consequently, in the logical test of your IF formula, you should use one of these functions: AND function-returns TRUE if all the conditions are met; FALSE otherwise.

Detailed explanation-2: -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-3: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.

There is 1 question to complete.