f(x)=x^3 formula in excel
Min max formula??
Ideally with ^1.125 where negative input numbers are increased the larger the number (1^1.125=1, 10^1.125=13.33521432), and the same happens with positive numbers in the other direction.
The question is how does one write this formula into excel? It has things on either side of the = sign. I'm trying to min/max a number as an output.
For example
-5 A1 = -25 B1
+5 A2 = +25 B2
-2 A3 = -4 B3
+2 A4 = +4 B4
-10 A5 = -100 B5
+10 A6 = +100 B6
I've used ^2 here but I'd like control over that. The above math equation is what I found on the web. I know there is a mathamatical way of describing this.
This is an image of the graph I'm looking for. The X axis is the input number.
maxmin2.gif
Thanks
Bookmarks