ISREF Function (Functions in Excel)

TRUE	=ISREF(A1)
FALSE	=ISREF(B99)
FALSE	=ISREF(Hello)
FALSE	=ISREF(10)
FALSE	=ISREF(NOW())
FALSE	=ISREF("A1")
FALSE	=ISREF(XX99)

What Does It Do ?

This function shows TRUE if given a cell address, or FALSE for any other type of value.

Its a bit of an odd one, and is normally used in macros rather than on the worksheet.

Syntax

=ISREF(ValueToTest)

The ValueToTest can be any type of data, but when used on the worksheet, it cannot be a

reference to the contents of another cell, as the reference will itself be evaluated by the function.

Formatting

No special formatting is needed.

Related Posts by Categories

Excel Notes

• How to create a template in excel 2007?
• Tips for Setting Up a Table in Excel
• Table Terms in Excel
• Sorting Data in Excel (Sort Button and Sort Dialog Box)
• Separating Text in Excel (Separating the Data)
• Separating Text in Excel (Considerations)
• Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)
• Hiding Columns, Rows, and Cells in Excel (Hiding Rows)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)
• Hiding Columns, Rows, and Cells in Excel (Hiding Columns)
• Find and Replace Features in Excel (Using the Replace Feature)
• Find and Replace Features in Excel (Using the Find Feature)
• Paste Special Feature in Excel (Paste Special Options)
• Paste Special Feature in Excel (Using the Paste Special Dialog Box)
• Using the Fill Command in Excel (Filling Cells, Filling Cells: Ribbon Option, Filling Cells: Mouse Option, Working with Custom Fills, Creating a Custom Fill, Importing Custom Fills, Using a Custom Fill)
• Working with Comments in Excel (Adding Comments, Adding Comments: Ribbon Option, Adding Comments: Mouse Option , Editing Comments, Editing Comments: Ribbon Option, Editing Comments: Mouse Option, Displaying/Hiding Comments, Displaying/Hiding Comments: Single Cell , Displaying/Hiding Comments: Ribbon Option, Displaying/Hiding Comments: All Cells , Moving Comments , Deleting Comments, Removing Comments from a Single Cell: Mouse Option, Removing Comments from a Single Cell: Ribbon Option, Removing Comments from All Cells, Printing Comments)
• Importing an External Data File in Excel
• Working with Rows and Columns in Excel (Adjusting Row Height and Column Width, Adjusting Row Height: Ribbon Option, Adjusting Row Height: Mouse Option, Adjusting Column Width: Ribbon Option, Adjusting Column Width: Mouse Option, Using AutoFit to Adjust Rows and Columns, Using AutoFit to Adjust Row Height: Ribbon Option, Using AutoFit to Adjust Column Width: Mouse Option, Using AutoFit to Adjust Column Width: Ribbon Option, Adding and Removing Rows and Columns, Adding Rows, Adding Columns, Deleting Rows, Deleting Columns)
• Calculating Subtotals in Excel (Adding Subtotals , Adjusting Views with Subtotals , To expand the view one level:, To collapse the view one level: , Removing Subtotals , Re-sorting the Data )
• Calculating with Functions in Excel (Parts of a Function , Inserting Functions, Inserting Functions: Dialog Box Option, Inserting Functions: Ribbon Option, About the Function Arguments Dialog Box, To access the Function Arguments dialog box:, Inserting Functions with the Point and Click Method, Adding Cells Together, Adding a Range of Cells with the SUM Function)
• Editing Cell Contents in Excel (Moving Information, Drag and Drop vs. Cut and Paste, Moving Information: Drag and Drop , To Undo Drag and Drop:, Moving Information: Cut and Paste , Copying Formulas, Copy and Paste )
• Working with Conditional Formatting in Excel (Applying Preformatted Rules , Applying Cell Highlighting , Applying Top, Bottom, and Average Rules , Applying Data Bars, Color Scales, and Icon Sets , Creating a Customized Rule , Editing Rules , Prioritizing Rules , Deleting Rules )
• Formatting Numbers in Excel (Formatting Numbers: Toolbar Option , Formatting Numbers: Ribbon Option , Formatting Numbers: Dialog Box Option , Clearing Number Formatting )
• Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )

Functions in Excel

• YEARFRAC Function (Functions in Excel)
• YEAR Function (Functions in Excel)
• WORKDAY Function (Functions in Excel)
• WEEKDAY Function (Functions in Excel)
• VLOOKUP Function (Functions in Excel)
• VARP Function (Functions in Excel)
• VAR Function (Functions in Excel)
• VALUE Function (Functions in Excel)
• UPPER Function (Functions in Excel)
• TRUNC Function (Functions in Excel)
• TRIM Function (Functions in Excel)
• TREND Function (Functions in Excel) WHAT IS CONST b ?
• TRANSPOSE Function (Functions in Excel)
• TODAY Function (Functions in Excel)
• TIMEVALUE Function (Functions in Excel)
• TIME Function (Functions in Excel)
• TEXT Function (Functions in Excel)
• T Function (Functions in Excel)
• SYD Function (Functions in Excel)
• SUMPRODUCT Function (Functions in Excel)
• SUMIF Function (Functions in Excel)
• SUM and the =OFFSET Function (Functions in Excel)
• SUM (Running Total) Function (Functions in Excel)
• SUM Function (Functions in Excel)
• SUBSTITUTE Function (Functions in Excel)