Microsoft Office Tutorials and References

In Depth Information

**FALSE**

Another example of using the
AND
function with the
IF
function is in conjunction with

timelines. If you want to plot names, numbers, symbols, text, or colors over time you can create

dynamic time lines by moving giant charts. Notice the example in Figure 8.2. The formula in

cell G8—
=IF(AND(G$7>=$D8,H$7<$E8),$F8,””)
—states, if the date in G7 is greater than or

equal to the start date in cell D8, and the date in cell H7 is less than the stop date in cell E8,

then plot the result in cell F8 for $50. Other wise, leave the cell blank.

Apply relative referencing with dollar signs to anchor the formula reference. This means, when you

drag the formula to the right, it holds either the row number or the column letter depending on which

one you have the dollar sign in front of.

TIP

F

The dynamic Gantt chart formula

C

Start date

Figure 8.2

Use the
AND
function

in conjunction with the

IF
formula when

building dynamic time

lines to automatically

move money, names,

colors, and symbols.

1

Plot any of

these

D

Stop date

E

Result

B

Timeline

FALSE

FALSE
returns the value
FALSE
. There are no arguments associated with this function.

=FALSE()

The
FALSE
function can be typed directly into a cell as false and Excel will interpret the text as the

false function. The
FALSE
and
TRUE
functions are primarily for compatibility with other spreadsheet

programs (Lotus 1-2-3 in particular). If you know you will be sharing/exporting a workbook to

another spreadsheet program, it would be to your advantage to use the functions to express
TRUE

or
FALSE
so that those other programs interpret them as real true/false expressions. Failure to do

so might yield unexpected results (in those other programs) because a
TRUE
or
FALSE
entered

directly into a cell may be interpreted as text rather than as a logical expression.