Using math-formulas like a TI84-calculator

[gangnam]

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 ...

[TABLE="width: 464"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]function
[/TD]
[TD]y=[/TD]
[TD]x^3+x+2[/TD]
[TD]-2^3+-2+2[/TD]
[/TR]
[TR]
[TD]startvalue x
[/TD]
[TD="align: right"]-2[/TD]
[TD][/TD]
[TD="align: right"]-2[/TD]
[/TR]
</tbody>[/TABLE]

 

[jorismoerings]

Hi and welcome to MrExcel,

Excel 2016 (Windows) 64 bit
	A	B
18	-2	-8
19	-1	0
20	0	2
21	1	4
22	2	12
Sheet1

Cell Formulas
Range	Formula
B18	=A18^3+A18+2

and copy down to your needs.

 

[gangnam]

Thank you for your answer ... but

that's what I particulary don't want to do.

It is for a blind student.

One stop, one go.


Working like TI-84 or the calculation sheet in Geogebra

 

[jorismoerings]

Hi,

Take a look at this : http://www.jkp-ads.com/downloadscript.asp?filename=ChartAnEquation.zip
With thanks to Jan Karel Pieterse.

 

[gangnam]

Hi,

Take a look at this : http://www.jkp-ads.com/downloadscript.asp?filename=ChartAnEquation.zip
With thanks to Jan Karel Pieterse.

This is realy the purpose ...
But not in a chart ... that would not be recognized by a blind one.

Is it possible to put the points (x, y) in the chart to cells ... that would do the trick ...

 

[gangnam]

I got a solution
Thanks Joris for your replies