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.
Search JabSto ::




Custom Search