### Latest Post

4/recent/ticker-posts

# Excel Logical Category Functions & Errors with Examples

Today we discuss in this post Excel Errors & Logical Category Functions like- AND, OR, NOT, IF etc. so please read this post carefully for understanding text category important functions.

## AND

This function returns TRUE if all of its arguments are TRUE, returns FALSE if one or more arguments evaluate to FALSE

Syntax

AND(logical1, [logical2], ...)

Example - In figure

## NOT

This function reverses the logic of its argument.

Syntax

NOT(logical)

NOT is a value or expression that can be evaluated to TRUE or FALSE

Example - In figure

## OR

This function returns TRUE if any argument is TRUE

Syntax

OR(logical1,logical2,...)

Example - In figure

## IF

The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE

Syntax

IF(logical_test, value_if_true, [value_if_false])

Example - In figure

## IFERROR Functions

This function returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula

Syntax

IFERROR(value,value_if_error)

USE OF EXCEL FORMULAS SUM, SUMIF & SUMIFS

## ##### error

This error show that a column is not wide.

Solution

Pleas set the width of columns.

## #DIV/0! error

Excel show this #DIV/0! error when a number is divided by zero .

Solution

Check the value and suggest.

## #N/A error

This error indicates that a value is not available in formula.

Solution

Data is missing. Please check data.

## #NAME error

This error occurs when Excel does not recognize text in a formula.

Solution

## #NULL! error

This error occurs when you specify an intersection of two areas that do not intersect.

Solution

## #NUM! error

This error indicates that a formula or function contains invalid numeric values.

Solution

## #REF! error

This error occurs when a cell reference is not valid.

Solution

You may have deleted cells that were referred to by other formulas.

## #VALUE! error

Excel can display the #VALUE! error if your formula includes cells that contain different data types.

Solution