FormulaText function in Excel was introduced in version 2013. It requires just one parameter – the cell from which you want to display the formula. Even if you select a range, it will return the formula in the top left cell.
When to use the FormulaText function in Excel
Here are three practical scenarios.
It is very helpful in documenting important formulas.
It can also be used as a part of an audit process.
Trainers can use it to teach formulas more effectively.
I find it useful for creating more readable screenshots while creating learning content for Excel.