I am really interested in knowing how the lookup function table works.
How do I convert a specific number into an X location on the table
I have this "defined" table:
0,400,800,1200,1600,2000,2400,2800,3200,3600,4000,4400,4800,5200,5600,6000,6400,6800,7200,7600,8000 for X axis
if i have an independent variable of 4000, the result should be 11 on the lookup, but how do I perform this function? Or how do I create this table with those Xs or labels?
The code I am looking at looks like this
in theory it should result in 11, but it results in 500 for D2 ($1F4).
Any help is REALLY appreciated.