Logical Functions in Excel 2010/Logical functions with example

Logical Functions in Excel 2010

Logical functions with example

How to you logical functions in excel 2010, 2007

1.And function/ And function with example

Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE

And(logical1,logical2,….)

2.If function/If function with example

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

IF(logical_test,value_if_true,valu_if_false)

3.Or function/ Or function with example

Checks whether any of the arguments are TRUE, and returns TRUE or FALSE, Returns FALSE only if all arguments are FALSE

OR(logical1,logical2,…)

4. False function/False function with example

Returns the logical value FALSE

False()

5.True function/ True function with example

Returns the logical value TRUE

True()