Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to retrieve first match between two ranges in Excel
  • How to create dynamic named range with OFFSET in Excel
  • To count total rows in a range in Excel
  • Create hyperlink with VLOOKUP in Excel
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Filter Data Based on Date in Excel
  • How to Use Solver Tool in Excel
  • How to sum a total in multiple Excel tables
  • How to count table rows in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • Excel Data validation allow weekday only
  • Excel Data validation allow uppercase only

How to use Excel FORMULATEXT function

by

This Excel tutorial explains how to use the FORMULATEXT function with syntax and examples.

Excel FORMULATEXT function Description

FORMULATEXT function can be used in troubleshooting and auditing.  The Excel FormulaText function returns a formula as a text string.

Explanation:  The Excel FORMULATEXT function returns a formula as a text string from given reference. You can use FORMULATEXT to extract a formula as text from a cell. If you use FORMULATEXT on a cell that doesn’t contain a formula, you’ll get an #N/A error.

Syntax

FORMULATEXT (reference)

Note: where the reference argument is a reference to a cell in an Excel worksheet. This may be in a different worksheet in the current workbook, or in another workbook that is currently open.

If the supplied reference refers to a workbook that is not currently open, the FormulaText function will return the #N/A error.

Returns

The formula as text

Post navigation

Previous Post:

How to use Excel HLOOKUP Function

Next Post:

How to use Excel OFFSET function

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • How to count total words in a range in Excel
  • How to use double quotes inside a formula in Excel
  • How to extract last two words from text string in Excel
  • RIGHT, RIGHTB functions: Description, Usage, Syntax, Examples and Explanation
  • How to calculate project start date based on end date in Excel
  • Count day of week between dates in Excel
  • DATE function: Description, Usage, Syntax, Examples and Explanation
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • Get day name from date in Excel
  • Calculate periods for annuity in Excel
  • Calculate payment periods for loan in Excel
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • How to set check register balance in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles