| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Slow Calculating
My formula calculating is very slow, formula is as under & my active cell is
E5 ! E5 12345 J5 =IF($E5="","",IF(ISNA(VLOOKUP($E5,sl,11,)),"",VLOO KUP($E5,sl,11,))) L5 6,200 (this cell has unit price) M5 115.00 (this cell has exchange rate) N5 =$L5*IF($M5=0,1,$M5) O5 =SUMPRODUCT(($E$5:$E5=$E5)*($L$5:$L5<0)*($L$5:$L5) ) Even C5 doesn't have any formula just I am putting date but still taking long time than normal. Any idea to make it faster ? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
| Calculating is very slow | Excel Discussion (Misc queries) | |||
| Microsoft request for slow-calculating workbooks | Excel Discussion (Misc queries) | |||
| Microsoft request for slow-calculating workbooks | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Threaded Mode
