Search code examples
excelcellequations

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.

Solution

  • 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). :)