Forum Discussion
Display formula results as values within formula
I wondered if I asked excel to add A1+A2+A3
Let's say those values are:
A1 = 1
A2 = 2
A3 = 3
So the result would be 6
But what if I want excel to spell it out within the cell now:
=1+2+3
Is there a way to convert those linked formula into values?
2 Replies
If concrete this formula it could be parsed and calculated. For more abstract case and more complex formulas you may
1) enter it as text into any cell
2) create named formula for EVALUATE this cell
3) calculate this named formula
Of course, you always may use VBA programming and to create your own function(s)
