CODEWITHSUNDEEP
excelcellequations
pmdci
pmdci

Reputation: 300

Insert an equation (equation editor) in Excel using cell values as variables

I would like to insert an equation in Excel using the equation editor. However I would like to use values of specific cells as variables for the equation.

Consider this over-simplistic example: X + Y = Z

I would like to ensure that X would show the value of cell A1, Y would show the value of B2 and Z the value of C2.

I can create the Excel function on the background without any issues. But what I want to do here is display the notation of the equation in a nice format.

Is this possible at all?

Regards, P.

Upvotes: 2

Views: 2528

Answers (2)

pmdci
pmdci

Reputation: 300

Just to update this for completeness sake. I spoke with team members of the Excel dev team and what I was trying to achieve is not supported. They like the idea though, and they will "consider it for a future version of Excel" (whatever that means). :)

Upvotes: 2

gtwebb
gtwebb

Reputation: 3011

If I'm reading your question right you could just concatenate it as a string.

= A1 & " + " & B2 & " = " & C2

Upvotes: 0

Related Questions