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.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.