vosmerkin
05-06-2007, 11:32 PM
For example I have a some big formula that should process big arrays, I have a table where each cell contains such formulas. Also I need to hide zeros so I write such a formula
=IF(formula=0;"";formula)
where formula - my big formula with arrays.
In this case formula is recalculated twice. It takes to much time to recalculate whole the spreadsheet with 6 tables of about 1000 cells with this formulas.
Is there some possibility to reduce time of recalculating?
Maybe some variable in formula?
=IF(formula=0;"";formula)
where formula - my big formula with arrays.
In this case formula is recalculated twice. It takes to much time to recalculate whole the spreadsheet with 6 tables of about 1000 cells with this formulas.
Is there some possibility to reduce time of recalculating?
Maybe some variable in formula?