parameter of specific formulas automatically into excel sheet???

**blondie1986** · 02-07-2012, 12:48 AM

With Excel and some history Data I created a couple of graphs.
With these graphs I developed some Formulas, e.g.

=IF(AND(A2>=0,A2<=17), -2.42113 *(A2)^5 + 118.86272 *(A2)^4 - 2123.97608 *(A2)^3 + 16475.45073 *(A2)^2 - 42279.29719 *(A2) + 33369.98344,IF(AND(A2>=18,A2<=32),1.0271296 *(A2)^5 - 131.997141 *(A2)^4 + 6734.9126986 *(A2)^3 - 170542.560289 *(A2)^2 + 2144134.3847458*(A2) - 10420910.9560574,IF(AND(A2>=33,A2<=50),-0.0421471269 *(A2)^6 + 9.9702044355 *(A2)^5 - 975.9603106615 *(A2)^4 + 50585.0367640155 *(A2)^3 - 1463750.08508272 *(A2)^2 + 22414736.0176103 *(A2) - 141550785.040264,328286)))

Is it possible to have a function that excel automatically pull out all the Parameters of this formulas and put them directly in another excel sheet?
Otherwise I have to do it manually and there are quite a lot of these formulas I am having.

Your help will be appreciated!!!!!

**dilipandey** · 02-07-2012, 01:27 AM

Hi blondie,

By parameters - do you mean the references like 0, 17, -2.42113 etc ? If yes, then you can put them into excel sheet and put the reference into the formula. If you want to have these references on another sheet, just copy them into next sheet with formula. Alternatively, if you need these references to be fixed, you can put $ sign before and after the reference. Let me know if I am incorrect in my understanding. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**blondie1986** · 02-07-2012, 01:54 AM

Hi, no by parameters i only mean the numbers in front of this: *(a2)^6, e.g.
-2.42113
+ 118.86272

but can expel put these parameters automatically into another excel sheet or do i have to go one by one thru all the formulas and put them in a new sheet myself?

**bebo021999** · 02-07-2012, 02:52 AM

Pls see attachment. I use a helper column to find out position of each "*" and get the number right in front of "*"
Column A,B for text1; C,D for text2, and so on...