Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile This article describes the formula syntax and usage of the FORMULATEXT function in Microsoft Excel. Description Returns a formula as a string. Syntax FORMULATEXT(reference) The FORMULATEXT function syntax has the following arguments.

A clear list of over 200 Excel shortcuts for both Windows and Mac, side-by-side. Start a new line in the same cell.

• Reference Required. A reference to a cell or range of cells. Remarks • The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell.

• The Reference argument can be to another worksheet or workbook. • If the Reference argument is to another workbook that is not open, FORMULATEXT returns the #N/A error value. • If the Reference argument is to an entire row or column, or to a range or defined name containing more than one cell, FORMULATEXT returns the value in the upper leftmost cell of the row, column, or range.

• In the following cases, FORMULATEXT returns the #N/A error value: • The cell used as the Reference argument does not contain a formula. • The formula in the cell is longer than 8192 characters. Mp4 or mov for mac. • The formula can't be displayed in the worksheet; for example, due to worksheet protection. • An external workbook that contains the formula is not open in Excel. • Invalid data types used as inputs will produce a #VALUE! • Entering a reference to the cell in which you are entering the function as the argument won't result in a circular reference warning. FORMULATEXT will successfully return the formula as text in the cell.

Example Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

If you need to, you can adjust the column widths to see all the data. Formula Description Result =TODAY() The formula in C2 returns the formula it finds in cell A2 as a text string so that you can easily inspect its structure.

The formula entered in A2 is =TODAY(), and will return the current day in A2. The formula =TODAY() should appear as text in C2.

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010 This article describes the formula syntax and usage of the CELL function in Microsoft Excel. Find links to more information about formatting the data in cells and applying cell styles in the See Also section. Description The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula: = IF( CELL('type', A1) = 'v', A1 * 2, 0) This formula calculates A1*2 only if cell A1 contains a numeric value, and returns 0 if A1 contains text or is blank.