Notifications
Clear all
Excel Expert
3
Posts
2
Users
0
Reactions
101
Views
Topic starter
Hi, Say I have the following data:
- Cell L13 has the equation "=B20/D5"
- Cell B20 = 45
- Cell D5 = 5
So, I have used "=FORMULATEXT(L13)" to display the equation as "=B20/D5".
But how do I display in another cell the actual figures used? So the new cell would display as "=45/5".
Many thanks, Edward.
Posted : 08/08/2022 2:13 am
Hi Edward,
There's no built in way to do this. You'd have to reconstruct the formula in a text string e.g.
=B20&"/"&D5
Which would return:
=45/5
Mynda
Posted : 08/08/2022 6:07 am
Topic starter
Many thanks Mynda, I've used that solution.
Posted : 09/08/2022 3:01 am
