Working with functions (III)
 Logical functions : FALSE () function Returns the logical value FALSE. Example: =FALSE() returns FALSE   TRUE () function. Returns the logical value TRUE. Example: =TRUE() returns TRUE   IF (logic_test;value_if_true;value_if_false) function Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Example: =IF(5=5;"Is true ";"Is Not true") returns Is true. Example: =IF(A1>=0;A1;0) The cell that contains this formula will contain the value of cellA1 if it is positive, and a zero if it is negative. This function is very handy when trying to obtain values based on some condition.   NOT (logical) function Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value. Example: =NOT(FALSE) returns TRUE   AND (logical1;logical2;...) function Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE Example: =AND(A1>0;B3=5;C4<0) returns TRUE if there is a positive value in A!, in B# a 5, and in C4 a negative.     OR (logical1;logical2;...) function Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE. Example: =OR(A1>0;B3=5;C4<0) returns TRUE if there is a positive value in A1, or a 5 in B3, or a negative in C4.     Information Functions: ISBLANK (value) function Returns TRUE if the value is blank Example: =ISBLANK(A2) returns FALSE if cell A2 is empty.   ISERR(value) function Returns TRUE if the value is any error value except #N/A Example: =ISERR(A+23) returns TRUE.   ISLOGICAL(value) function Returns TRUE if the value is a logical value Example: =ISLOGICO(A1) returns TRUE if there is a true or false value found in A1.   ISNONTEXT (value) function Returns TRUE if the value is not text Example: =ISNOTEXT(A1) returns TRUE if there is no text in A!, eg if A1 contains a date (dates are numbers)     ISTEXT (value) function Returns TRUE if the value is text Example: =ISTEXT(A1) returns FALSE if there is a date in A1.   ISNUMBER (value) function Returns TRUE if the value is a number Example: =ISNUMBER(A1) returns TRUE if there is a number in A1.   TYPE (value) function Returns a number indicating the data type of a value Example: =TYPE(A1) returns 16 if there is an error in A1.
 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.