Thanks, unfortunately that didn't help. I have to be able to modify the input
through additional formulas and have the equations change. I thought there
would be a ctrl function or something.

"Gord Dibben" wrote:

Would this help at all?

You could employ a user defined function and go the other way.

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

Enter 2+3 in A1 then in an adjacent cell enter =EvalCell(A1) to return 5

Probably not too practical if the 2 and 3 in A1 and A2 are formula-generated.


Gord Dibben MS Excel MVP



On Mon, 4 Jun 2007 16:55:01 -0700, tralst
wrote:

I don't need it for evaluation. My customer wants me to show all work in the
equations that I am using. In other words I would have 3 cells:

="Number1+Number2"
=A1&"+"&A2
=A1+A2

The actual equations are much more complicated and it takes a lot of time to
format them with the &'s included.

"joeu2004" wrote:

On Jun 4, 2:22 pm, tralst wrote:
I know that I can show the work in a formula by simply using a &. Example,
with A1 =2 and A2 =3, I type =A1+A2 in a cell This can be converted to the
cells values by entering =A1&"+"&A2. This will return 2+3 in the cell. My
question. Is there a shortcut to accomplish this?

I think you might be interested in the Evaluate Formula feature.
Typically, you select the cell with the interesting formula, then
click on Tools - Formula Auditing - Evaluate Formula. Even though
the feature has some limitations, it is often helpful in debugging or
understanding many complex formulas.