DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Function And
|
|
|
Fungsi Or
|
|
|
Note function
|
|
|
IF function
|
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: -A conditional statement is a statement that can be written in the form “If P then Q, ” where P and Q are sentences. For this conditional statement, P is called the hypothesis and Q is called the conclusion. Intuitively, “If P then Q” means that Q must be true whenever P is true.
Detailed explanation-3: -You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. logical test: The condition that you want to check. value if true: The value to return if the condition is True.
Detailed explanation-4: -The AND function in Excel checks if every argument you put in it evaluates to TRUE. If everything evaluates to TRUE, then the function will return TRUE, otherwise, even if only one argument is FALSE, the function will return the value FALSE. This is the sister function to the OR function.