I am new to this and am trying to create an excel sheet in which I can insert any equation in terms of x into a specific cell, and then in a different cell substitute any number into that equation for x, but I'm running into some problems.
For example, I insert x+3 into A1, and then in A2 I type the formula =SUBSTITUTE(A1,"x",3). This produces the result of 3+3 in A2. 3+3 is now a text string, and I don't know how to turn it into a number. All help is appreciated.
Bookmarks