Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to create a Histogram in Excel
  • Add Outline to Data in Excel
  • How To Compare Two Lists in Excel
  • How To Load Analysis ToolPak in Excel
  • Conditional Formatting Data bars Examples in Excel

References

  • How to use Excel COLUMN Function
  • Offset in Excel
  • How to retrieve first match between two ranges in Excel
  • Basic INDEX MATCH approximate in Excel
  • Create hyperlink with VLOOKUP in Excel

Data Validations

  • How To Create Drop-down List in Excel
  • Excel Data validation date in next 30 days
  • Excel Data validation must contain specific text
  • Prevent invalid data entering in specific cells
  • Excel Data validation specific characters 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

Logical Functions

  • How to use Excel TRUE Function
  • How to use Excel OR Function
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel

Date Time

  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Add decimal minutes to time in Excel
  • How to calculate months between dates in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate workdays per month in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • How to randomly assign data to groups in Excel

General

  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to generate random times at specific intervals in Excel
  • How to get original price from percentage discount in Excel
  • How to get Excel workbook path only
  • How to create dynamic named range with INDEX in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning