View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JeffV JeffV is offline
external usenet poster
 
Posts: 1
Default can excel automatically collect variables to redue a formula's si.

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