Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Digging Up the Facts
correctly understood. The dates in Column A are of the d-mmm format. The
downside of this format is that the year is not known. So, cell A1 has been
given a formula that uses CELL to test the dates’ format. If the d-mmm format
is found in the first date (in cell A4), then cell A1 displays a message that
includes the year from cell A4. After all, cell A4 has a year — it’s just
formatted not to show it. This way the year is always present — either in the dates
themselves or at the top of the worksheet.
The formula in cell A1 — =IF(CELL(“format”,A4)=”D2”,”Receipts
for “&YEAR(A4),”Receipts”) — says that if the formatting in A4 is
d-mmm (according to the values in Table 15-2), then display the message with
the year; otherwise, just display Receipts.
Here’s how to use the CELL function:
1. Position the cursor in the cell where you want the results to appear.
2. Enter =CELL( to begin the function entry.
3. Enter one of the first argument choices listed in Table 15-1.
Make sure to surround it with double quotes ( “ ”).
4. If you want to tell the function which cell or range to use, enter a
comma ( ,).
5. If you want, enter a cell address or the name of a range.
6. Enter a ), and press Enter.