Pages

Friday, March 22, 2013

CELL Function

The CELL Function is a standard function that will return information about the current operating system. See CELL is Excels help for details.

Formula

Result

=MyName()

Workbook Path.xls

=MyFullName()

C:\OzGrid\Learning\Workbook Path.xls

=CELL("filename")

C:\OzGrid\Learning\[Workbook Path.xls]Sheet1

=sheetname(A1)

Sheet1

 

No comments:

Post a Comment