Returns the formula as a string.
grammar
FORMULATEXT(reference)
The FORMULATEXT function syntax has the following parameters:
Reference required. A reference to a cell or range of cells.
Instructions
■ If you select reference cells, the FORMULATEXT function returns what is displayed in the edit bar.
The Reference parameter can represent another sheet or workbook.
■ FORMULATEXT returns the #N/A error value if the Reference parameter represents another unown workbook.
■ FORMULATEXT returns rows and columns if the Reference parameter represents an entire row or column, or represents a region containing multiple cells or a defined name
Or the value in the top-left cell of the range.
■ FORMULATEXT returns error #N/A when:
The cells used as Reference arguments do not contain formulas.
The formula in the cell is more than 8192 characters long.
Unable to display formulas in a worksheet; For example, due to sheet protection.
The external workbook containing this formula is not open in Excel.
Invalid data types used as input will generate an error VALUE #VALUE! .
■ When a parameter does not cause a circular reference warning, enter a reference to the function in the cell where you want to enter it.
FORMULATEXT will successfully return the formula as text in the cell.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/