List of basic functions in Excel you should know
Before learning about the basic functions in Excel you should remember to learn to excel better you learn to do a lot of functions and exercises to apply in specific cases offline. Wish you research and academic success. Come to us begin to learn and understand the basic functions of Excel yet.
Logic synthesis function in Excel
OR function: the function returns TRUE if and only if a condition is TRUE
Syntax: OR (logical1, logical2, ..)
Identification to function: the problem with the word "or"
Example: Score> 8 or good behavior. Analysis: meaning that it can refer to the table if you do have any points> 8 or conduct is good, it will return the value TRUE
OR (score> 8, HK = "good") = TRUE
AND function: returns the value TRUE when two conditions simultaneously is TRUE
Syntax: AND (logical1, logical2, ..)
Identification variables: the problem with the word "and"
Example: Score> 8 and good behavior. Analysis: it will children about the value TRUE if the table that you do satisfy the two conditions is> 8 and good behavior
AND (score> 8, HK = "good")
IF function: returns the value in the first argument if the conditions 2 and returns the value TRUE in the 3rd argument if conditions FALSE
Syntax: IF (logical_test, value_if_true, value_if_false)
For more content if you see: if function in Excel
Identification signs: problems containing the word "If ... then .."
Example: If the point of> 9 are rated excellent other cases, it ranked pretty
IF (score> 9, "good", "fair")
See also: if function in Excel
