Microsoft Office Tutorials and References
In Depth Information
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.
The dynamic Gantt chart formula
Use the AND function
in conjunction with the
IF formula when
building dynamic time
lines to automatically
move money, names,
colors, and symbols.
Plot any of
FALSE returns the value FALSE . There are no arguments associated with this function.
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.