excel-combining several long formulas
excel-combining several long formulas
(OP)
anyone have a way to combine several long formulas in to one formula? the formulas are long and when i start adding them together in to one formula (one cell), excel eventually tells me the formula is too long. or is there a way to "optimize" a formula or set of formula to remove/combine common variables (sort of like eq1=x+2x+y+5x+2y-->eq1new=8x+3y) except that the equations i am dealing with are much more involved than the simple one i used as an example.
essentially, i've got to combine several long formulas in to one cell for the sake of applying it to many rows of data. i would like to set it up as a drag and drop equation since there's a few thousand cells of data.
i would prefer to stay away from using macros or solver functions. i've already got the equations broken apart in multiple cells...now i've just got the problem of combining them in to one cell and the program limits the formula length.
thanks in advance
essentially, i've got to combine several long formulas in to one cell for the sake of applying it to many rows of data. i would like to set it up as a drag and drop equation since there's a few thousand cells of data.
i would prefer to stay away from using macros or solver functions. i've already got the equations broken apart in multiple cells...now i've just got the problem of combining them in to one cell and the program limits the formula length.
thanks in advance





RE: excel-combining several long formulas
RE: excel-combining several long formulas
As far as execution speed, I think excel formula's are often quicker. Don't know if that is a big issue in your situation.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: excel-combining several long formulas
You may be lucky.
Personally I often build long equations up across several columns, then just copy the whole lot down for the whle lot of data.
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: excel-combining several long formulas
That or write a UDF, which will be much easier to check, and give you much more flexibility. If recalculation speed is an issue you can read all the data into an array, write the results into an array inside VBA, then paste the function as an array function, so that the data transfer between the spreadsheet and VBA only occurs once per calculation, not once for every cell. Performance should then be as good or better than a complex worksheet formula.
Doug Jenkins
Interactive Design Services
www.interactiveds.com.au
RE: excel-combining several long formulas
Dik
RE: excel-combining several long formulas
RE: excel-combining several long formulas
http://ne
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: excel-combining several long formulas