workbook size and calculations

[Hugh]

Hope this doesn't come across as a REALLY stooopid question.

Which is more efficient as far as workbook size, simple =FUNCTION(A,B)
formula's in say, a dozen adjacent cells, or nested formulas in a single
cell?

Does it make any real difference in workbook size? Dozen worksheets,
250+ rows, up to 40 columns of calculations.

TIA

 

[Charles Williams]

generally speaking the more cells you use the larger the workbook, because
there is an overhead associated with each cell that is used. The size of the
overhead depends on how much information you ask Excel to hold about each
cell.
The effect on calculation time is different: it usually does not make much
difference if you have a huge megaformula or split it into a lot of
different cells as long as you are asking Excel to do the same number of
calculation steps.

The golden rule on calculations is to only do each calculation once, and
then refer to the cell containing the result, rather than repeating
identical bits of formulae.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com