I have a small maths problem. I am trying to create a relationship between two sets of numbers. The non-linear value comes from a light sensor and the other set of values are LUX levels. The values are as follows :-
I have plotted these values out and they appear to give a decaying exponential curve. What I am aiming for is two cells in excel, one in which I can enter a LuX value and the other cell will display the associated ohms value.