LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Running all data through a set of formulas

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
running totals, named formulas Memento Excel Worksheet Functions 1 May 8th 07 09:35 AM
pivot table formulas - running total Wade Lau Excel Discussion (Misc queries) 0 March 13th 07 08:01 PM
How can I save the formulas when running a macro? Need ASAP!! MLP Excel Discussion (Misc queries) 2 November 14th 06 07:50 PM
Keeping formulas on running total and sorts LoriM1 Excel Worksheet Functions 0 April 19th 06 02:58 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"