can excel automatically collect variables to redue a formula's si.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

can excel automatically collect variables to redue a formula's size. An
example of what I'm trying to reduce is below,

=1.49*(((PI()*(360*(2*ACOS(1-2*I17/G17))/(2*PI()))-180*SIN(2*ACOS(1-2*I17/G17)))*(G17^2/1440))/144)*(((1-180*SIN(2*ACOS(1-2*I17/G17))/(PI()*(360*(2*ACOS(1-2*I17/G17))/(2*PI()))))*(G17/4))/12)^(2/3)*J17^0.5/N17
 
You could, perhaps, use a defined name (or put a piece of the computation in
another cell and just reference that cell in your larger formula).

As an example using a defined name, click insert/names/define. For name, I
will use "x".
Refers To: =2*ACOS(1-2*$I$17/$G$17)

Then your formula would be:
=1.49*(((PI()*(360*x/(2*PI()))-180*SIN(x)))*(G17^2/1440))/144)*(((1-180*SIN(x))/(PI()*(360*x)/(2*PI()))))*(G17/4))/12)^(2/3)*J17^0.5/N17

You could also use Laurent Longre's Morefunc add-in, which uses SETV and
GETV to store a value in a variable and retrieve it in your formula. See
here for more details:

http://xcell05.free.fr/
 
Back
Top