NOT FUNCTION

NOT FUNCTION

This article describes the formula syntax and usage of the NOT function in MS Excel.

Description

Reverses the value of the argument to make sure that the value is not equal to any particular value. It returns TRUE if the argument is False and returns FALSE the given condition or argument is True.

Formula SYNTAX

=NOT(condition) The NOT Function has the following arguments: ·         Condition = Required. A Value or expression that can be evaluated to either TRUE or FALSE.

  

EXAMPLE 1
=NOT(5+2=7)	Return a value FALSE. The condition that evaluates to True is reversed.
=NOT(18>20)	Returns a value TRUE. The argument is reversed.

Read More

OR FUNCTION

OR FUNCTION

This article describes the formula syntax and usage of the OR function in MS Excel.

Description

Returns TRUE if any argument is True and returns FALSE when all the given conditions or arguments are False.

Formula SYNTAX

=OR(condition1, condition2, …) The OR Function has the following arguments: ·         Condition1 = Required. The first argument in the OR Function is the first condition that you want to test. It can either be evaluated to TRUE or FALSE. ·         Condtion2 = Not Required. This is additional condition that you want to evaluate to either TRUE or FALSE. You can have up to 255 conditions.

REMARKS

·         The conditions defined must evaluate logical values, such as TRUE or FALSE or has array or cell references containing logical values. ·          Array or References that contains text or blank cells are ignored. ·          The AND Function will return the #VALUE! error if there are specific range that contains no logical values.

EXAMPLE 1
=OR(5-3=2,6+2=8)	Returns a value TRUE. The OR Function will return a value TRUE if any of the conditions evaluate to True.
=OR(10<6,5<2)	Returns a value FALSE because all the arguments evaluates to False.
=OR(8*2=16,2+2=6)	Returns a value TRUE. Check the first example for the reason.

Read More

AND FUNCTION

AND FUNCTION

This article describes the formula syntax and usage of the AND function in MS Excel.

 

Description

Returns TRUE if all conditions evaluate to True and returns FALSE when even one of the given conditions or arguments evaluate to False.

 

Formula SYNTAX

=AND(condition1, condition2, …   The AND Function has the following arguments: ·         Condition1 = Required. The first argument in the AND Function is the first condition that you want to test. It can either be evaluated to TRUE or FALSE. ·         Condtion2 = Not Required. This is additional condition that you want to evaluate to either TRUE or FALSE. You can have up to 255 conditions.

 

REMARKS

·         The conditions defined must evaluate logical values, such as TRUE or FALSE or has array or cell references containing logical values. ·         Array or References that contains text or blank cells are ignored. ·          The AND Function will return the #VALUE! error if there are specific range that contains no logical values.

 

EXAMPLE 1
=AND(5-3=2,6+2=8)	Returns a value TRUE because all the arguments or conditions evaluate to True.
=AND(10>6,5<2)	Returns a value FALSE because one or more conditions evaluate to False.

 

COMMON USAGE

The AND Function is also very useful in expanding the usefulness of another logical functions. The IF Function is an example. The IF Function contains logical tests which evaluates a condition and returns one value if the conditions evaluates to TRUE and another value when the condition evaluates to FALSE. By using the AND FUNCTION, you can add more conditions on the logical_test (up to 255 conditions).

 

EXAMPLE 2
=IF(AND(10+2=12,7+6=13),”CORRECT”,”WRONG”)	Returns a value CORRECT because all the conditions evaluate to True.
=IF(AND(3*2=6,5*8=9),”YES”,”NO, IT’S NOT”)	Returns a value NO, IT’S NOT because one or more of the conditions evaluate to False.

 

Read More

FALSE FUNCTION

FALSE FUNCTION

This article describes the formula syntax and usage of the FALSE function in MS Excel.

Description

Returns the logical value FALSE. There are no arguments as to the FALSE Function is concern.

Formula SYNTAX

=FALSE() You can also use the word FALSE directly to the worksheet or formula and MS Excel will interpret it as the logical function FALSE. This function is provided primarily for compatibility with other spreadsheet programs.

EXAMPLE
=FALSE()	Returns a Value FALSE.
=IF(A1>10,FALSE()) =IF(A1>10,FALSE)	Returns a Value FALSE if the value in cell A1 is equal or less than 10. Same result.

Read More

TRUE FUNCTION

TRUE FUNCTION

This article describes the formula syntax and usage of the TRUE function in MS Excel.

Description

Returns the logical value TRUE. There are no arguments as to the TRUE Function is concern.

Formula SYNTAX

=TRUE() You can also use the word TRUE directly to the worksheet or formula and MS Excel will interpret it as the logical function TRUE. This function is provided primarily for compatibility with other spreadsheet programs.

EXAMPLE
=TRUE()	Returns a Value TRUE.
=IF(A1<20,TRUE()) =IF(A1<10,TRUE)	Returns a Value TRUE if the value in cell A1 is equal or greater than 10. Same result.

Read More