Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Formula, one field complex or multiple table field simple

Please comment on whether it is best, (execution speed wise), to reach a complex result built by having a complex formula broken down into simpler sequential multiple simple formula fields with each field using the value of a previous field in its calculation and then the final field containing the complex result OR if whether it is best to use one field with a very complex formula to reach the same result?



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Formula, one field complex or multiple table field simple

on 2/12/2012, DbMstr supposed :
Please comment on whether it is best, (execution speed wise), to reach a
complex result built by having a complex formula broken down into simpler
sequential multiple simple formula fields with each field using the value of
a previous field in its calculation and then the final field containing the
complex result OR if whether it is best to use one field with a very complex
formula to reach the same result?


Breaking things down into smaller pieces so you can have individual
results for each piece will definitely require more processing. In this
context the answer is that it's better (performance-wise) NOT to invoke
extraneous processing whenever possible.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply
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
How do I remove a Calculated Field from the Pivot Table field list TheTraveler Excel Discussion (Misc queries) 2 April 9th 10 06:55 PM
Creating a Calculated Field in a Pivot Table for same field dza7 Excel Discussion (Misc queries) 3 October 21st 09 11:22 PM
sum a pivot table field as a calulated field Jerome Excel Discussion (Misc queries) 0 January 4th 08 03:24 PM
Calculated field in pivot table, simple Average formula Suzanne Excel Discussion (Misc queries) 2 March 23rd 07 11:58 AM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 30th 07 12:13 AM


All times are GMT +1. The time now is 04:07 PM.

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

About Us

"It's about Microsoft Excel"