For a blind student I'm making a excel-sheet working like a graphics-calculator table.
In Cel C10 I want to put the math-function using an "X".
In column A18 thru A38 there are some values for "X"
Then I want to display in column B18 thru B38 the calculated answers ... using the value for "X" in the neighbour cell.
For example in B18 I want to replace the "X" in the formula by the value in cell A18 ... and calculated.
How to do this?
Substitution is no problem, but I like to have it calculated ...
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
In Cel C10 I want to put the math-function using an "X".
In column A18 thru A38 there are some values for "X"
Then I want to display in column B18 thru B38 the calculated answers ... using the value for "X" in the neighbour cell.
For example in B18 I want to replace the "X" in the formula by the value in cell A18 ... and calculated.
How to do this?
Substitution is no problem, but I like to have it calculated ...
function | y= | x^3+x+2 | -2^3+-2+2 |
startvalue x | -2 | -2 |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>