Solved: variables in formulas

[vosmerkin]

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?

[geekgirlau]

Why don't you format the cell so that zeros are not visible? If you set the custom format to something like "#,##0;-#,##0;" you will not see zeros. You can get more information on the formatting options by looking at custom number formats in Help, but essentially the first 3 parameters give the format of a positive value, the format of a negative value, and the format of zero. By having nothing after the second semi-colon, you are effectively hiding zero values.

[vosmerkin]

Thanks, works fine.