FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function to find values ​​with a conditional statement is true or true and a conditional statement is false or false is called ____
A
Function And
B
Fungsi Or
C
Note function
D
IF function
Explanation: 

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.

There is 1 question to complete.
Previous
Next