Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically duplicate variables | Excel Worksheet Functions | |||
Creating Entries Automatically from Variables | Excel Discussion (Misc queries) | |||
automatically updating graphs based upon conditional variables | Charts and Charting in Excel | |||
collect data's from different excel files | Excel Worksheet Functions | |||
Collect numbers.... | Excel Discussion (Misc queries) |