View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zemarko Zemarko is offline
external usenet poster
 
Posts: 1
Default Calculation Time estimation


Hello,
I am trying to get my IBM T23 Laptop (1 Go RAM, Pentium III 1,13Ghz) to
calculate about 400K formulas of this kind

=IF(ISERROR(IF(OR($F2<(VLOOKUP($A2;'06'!A:H;6;FAL SE));ISTEXT(VLOOKUP($A2;'Tfr
07'!C:H;5;FALSE)));$G2/100;0));0;IF(OR($F2<(VLOOKUP($A2;'06'!A:H;6;FALSE ));ISTEXT(VLOOKUP($A2;'Tfr
07'!C:H;5;FALSE)));$G2/100;0))

and obviously the last time I tried, it stayed stuck for more than an
hour, so I stopped it. Does anybody has an idea about how long I would
need to let it work to get this done? Am I insane to try this or do I
just have a crappy computer?
Cheers


--
Zemarko
------------------------------------------------------------------------
Zemarko's Profile: http://www.excelforum.com/member.php...o&userid=37866
View this thread: http://www.excelforum.com/showthread...hreadid=574120