View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevesquared
 
Posts: n/a
Default Counting the number of calculations on a speadsheet


I design very large data models using Excel that calculates funding
levels for a government program I administer.

I am trying to quantify the degree of sophistication of a particular
data model for a layman.

Does anyone know an easy way to get Excel to compute for me how many
individual calculations are present in a particular workbook? By this I
mean looking at each formula and determining how many discreet
calculations are required (i.e. a nested Vlookup inside nested IF
statements could easily be 10 or more unique calculations).

Thanks!
Steve


--
stevesquared
------------------------------------------------------------------------
stevesquared's Profile: http://www.excelforum.com/member.php...o&userid=33725
View this thread: http://www.excelforum.com/showthread...hreadid=535052