Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the response guys, I was hoping there was a way to cusomize an
argument or us an "IF/THEN" type situation. I've already gone through the combining of formulas, the best it could be brought down to was 4 cells instead of 6. If it is combined into one cell, the calculations and fixed numbers in the cell must be changed in order to retain accuracy. It's variance increases greatly as the input data gets higher or lower than a set point. I've seen the formula in one cell and it is completely reworked from the four cell variation. If I could use it, I would, but it would cost a few hundred to purchase and use it. "Fred Smith" wrote: Without knowing the formula, we can't say for certain, but my bet is you can combine them. I would try to reduce them one at a time. Let's say your four formulas are in a2,b2,c2 and d2. Start with b2. Wherever a2 is used, substitute the formula that's in a2 If that works, do the same with the other cells. Regards, Fred. "-Bryan" wrote in message ... Let me put it another way, Is what I asked in the original post possible. Combining these formulas into one throws off the accuracy, and quite a bit of the calculations need to be changed. If it is possible, it would save a lot of time doing what I asked about, than recalculating the formula to fit in one box. "Pete_UK" wrote: Well, you are not likely to get much help, then !! Pete On Apr 29, 4:48 pm, -Bryan wrote: I wish I could, they are propietary, and I wouldn't be looked on kindly posting them on the web. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
running totals, named formulas | Excel Worksheet Functions | |||
pivot table formulas - running total | Excel Discussion (Misc queries) | |||
How can I save the formulas when running a macro? Need ASAP!! | Excel Discussion (Misc queries) | |||
Keeping formulas on running total and sorts | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |