Z
Zemarko
Hello,
I am trying to get my IBM T23 Laptop (1 Go RAM, Pentium III 1,13Ghz) t
calculate about 400K formulas of this kind
=IF(ISERROR(IF(OR($F2<>(VLOOKUP($A2;'06'!A:H;6;FALSE));ISTEXT(VLOOKUP($A2;'Tf
07'!C:H;5;FALSE)));$G2/100;0));0;IF(OR($F2<>(VLOOKUP($A2;'06'!A:H;6;FALSE));ISTEXT(VLOOKUP($A2;'Tf
07'!C:H;5;FALSE)));$G2/100;0))
and obviously the last time I tried, it stayed stuck for more than a
hour, so I stopped it. Does anybody has an idea about how long I woul
need to let it work to get this done? Am I insane to try this or do
just have a crappy computer?
Cheer
I am trying to get my IBM T23 Laptop (1 Go RAM, Pentium III 1,13Ghz) t
calculate about 400K formulas of this kind
=IF(ISERROR(IF(OR($F2<>(VLOOKUP($A2;'06'!A:H;6;FALSE));ISTEXT(VLOOKUP($A2;'Tf
07'!C:H;5;FALSE)));$G2/100;0));0;IF(OR($F2<>(VLOOKUP($A2;'06'!A:H;6;FALSE));ISTEXT(VLOOKUP($A2;'Tf
07'!C:H;5;FALSE)));$G2/100;0))
and obviously the last time I tried, it stayed stuck for more than a
hour, so I stopped it. Does anybody has an idea about how long I woul
need to let it work to get this done? Am I insane to try this or do
just have a crappy computer?
Cheer