Microsoft Office Tutorials and References
In Depth Information
Using the NA Function to Force Charts to Not Plot Missing Data
Figure 12.16.
Figure 12.16. Using
in the chart on the right allows the trendline to ignore
future missing data points and project a reasonable ending result.
Using NNA in the chart on the right allows the trendline to ignore
future missing data points and project a reasonable ending result.
22. You enter a formula in column C to keep track of the total collected
throughout the fund drive.
33. To avoid making it look like the fund drive collected nothing in days 10
through 14, you enter a formula in column C to check whether column
A is blank. If it is, then the IF function inserts a null cell in column
C. For example, the formula in cell C15 is
=IF(ISBLANK(A15),"",A15+C14).
Search JabSto ::




Custom Search