Microsoft Office Tutorials and References
In Depth Information
Using the SHEETS and SHEET Functions to Dynamically Build a 3-D Reference
Figure 12.13.
Figure 12.13. The formula in column D detects nontext ZIP Codes and con-
The formula in column D detects nontext ZIP Codes and con-
verts to text with five digits.
verts to text with five digits.
The formula in column D, =IF(ISNONTEXT(C5),RIGHT("0000"&C5,5),C5), fixes
errant ZIP Codes in column C. If the value in column C is nontext, the program
pads the left side of the ZIP Code with zeros and then takes the five rightmost
digits.
Using
Using the
the SHEETS
SHEETS and
and SHEET
SHEET Functions
Functions tto Dynamically
Dynamically Build
Build a 3-D
3-D
Reference
Reference
Both the SHEETS and SHEET functions are new in Excel 2013. It will be fas-
cinating to see how Excel gurus put these to use. SHEETS tells you how many
worksheets are in a workbook or reference. SHEET tells you the position of
one worksheet within the workbook.
Syntax
SHEETS()
SHEETS returns the number of worksheets in the workbook in which the func-
tion is entered. It includes worksheets that are hidden or very hidden.
Search JabSto ::




Custom Search