Microsoft Office Tutorials and References

In Depth Information

**Producing Logical and Informational Data**

Producing Logical and Informational Data

IF
IF
returns a value if one condition is true, and returns another value if the condition is false.

The
IF
function is used to compare logical tests and return text or numeric results. Notice in

Figure 2.5, there are three
IF
examples. The first example in cell E4, is used to compare whether

text in a cell equals the text of “Pass” in the formula, returns a text response based on the cell

input in D4. The second example in cell F11 in Figure 2.5 compares whether or not a value is

zero, and if so, returns zero or else adds two cells together. And the third example is a nested
IF
,

which returns a text result based on a numeric condition being met, and if the numeric condition

is less than the previous in the second, third, or fourth condition, the lower result is used.

ISNUMBER

The
ISNUMBER
function returns a value if the cell has a number.

The
ISNUMBER
example in Figure 2.5 is used to compare whether a numeric result is met in

cell D20, if so, it returns a text response if the condition is met, and False if it’s not.

ISBLANK

Return the value associated with the number of empty cells with the
ISBLANK
function.

ISBLANK
returns a logical True or False result based on whether a cell has data in it. Combined

with the
SUM
and
IF
functions, it can be used as a tracking function to return the result from a

specified range based on the result of another range. The example in Figure 2.5 shows the

function looking up how many dates are entered in a column and returns the actual page count

from column D. In essence, it tracks the pages based on vertical and horizontal processes.

Figure 2.5

Common
LOGICAL
and

information functions.