| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet Calculation | Excel Discussion (Misc queries) | |||
| #VALUE! in Time Calculation | Excel Worksheet Functions | |||
| perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
| "Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
| time calculation excel | Excel Worksheet Functions | |||
Threaded Mode
