Show A Formula In Text Format Using The FORMULATEXT Function – Excel Documentation
We cover how to get a formula in text form from a cell using the FORMULATEXT function. This function is useful for documentation purposes, especially if your workbook consists of complicated formulae and you want the user viewing it to understand how the values are calculated. In our example, we have a variable rate mortgage repayment calculator which accounts for changes in mortgage rates throughout the mortgage term. We have an amortisation table to the right which shows how the interest and principal change over time. If someone wants to quickly understand how the amortisation table is calculated and which functions are used, we can create a separate backend sheet which documents all of this.
Variable Rate Mortgage Repayment Calculator - Build An Amortisation Table In Excel:
• Variable Rate Mortgage Repayment Calc...
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Show A Formula In Text Format Using T...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
FORMULATEXT Function: (1:02)