Noel Mitchell as how to turn a long mathematical equation into an Excel equation and here is my reply.

Obviously, I have no idea which equation you are talking about but let me generalise a little. By the way, length of the equation could be a red herring.

  • I am going to guess that a long equation contains several different variables
  • I am going to guess that a long equation contains several different coefficients and possibly uses powers.

My equation, not so long, is Y = z + (aX)^2 + bX^(1/3) + cX + dX and in a situation like this, I would set out my work in this way:

Then I would apply what I have put into the input section in this way:

Consider the graph to be a bonus but I think it helps to prove the quality of my programming.

Since everything that might change is either in the input section or in the application table section, I can update any aspect of this worksheet in seconds.

No need for a downloadable file here, I think

Duncan Williamson

16th March 2020

%d bloggers like this: