Show sum in a cell in Excel-CodePudding

I have problem in excel:

Let's say in C2 its value is 1 1

and then in C3 I want to show the sum of C2 so the value of C3 will be 2.

I can do this in WPS using =EVALUATE(C2), but I can't do this in excel.

CodePudding user response：

If you can use VBA this might prove being very simple, as you can see from this screenshot:

The function evaluate_Formula() is defined in VBA as follows:

Public Function evaluate_Formula(target As Range)
  evaluate_Formula = Evaluate(target.Value)
End Function

As far as the way I have defined this, I'll add another screenshot for clarity reasons:

As you see, I've added a module, and I've added the mentioned VBA code into that module.
Don't worry about "Solver.xlam", this is not relevant to this matter.