If I am programming some methods on finding roots of equations using excel and was wondering if there was a way to do it so I didnt have to write an equation out each time and reprogram all the cells.
What I mean is....
If I have the equation x^2 + 2x +1 = 0
Can I put x^2 + 2x +1 into a cell and as the value of x changes, let it do it automatically?
As in if I have x = 3 and I put 3 in cell A1
can I program another cell to = x^2 + 2x +1 where x = A1 or something along those lines so it will sub in whatever calue I put in A1 without me having to change the equation?