Forum Discussion
Referencing a formula
This is because some of the rows in 'FDS RECTO'!Q59:S82 contain only zeros, and hence 'FDS RECTO'!P59:P82 contains zeros.
This is in turn, because some of the rows on the CCM sheet are empty. For example, CCM!D15 is empty, and hence the formula =CCM!D15 returns 0. This is a quirk of Excel.
One workaround is to change the formula in 'FDS RECTO'!P59 to
=IF(MIN(Q59:S59)=0,"",MIN(Q59:S59))
and fill it down to P82.
This is because some of the rows in 'FDS RECTO'!Q59:S82 contain only zeros, and hence 'FDS RECTO'!P59:P82 contains zeros.
This is in turn, because some of the rows on the CCM sheet are empty. For example, CCM!D15 is empty, and hence the formula =CCM!D15 returns 0. This is a quirk of Excel.
One workaround is to change the formula in 'FDS RECTO'!P59 to
=IF(MIN(Q59:S59)=0,"",MIN(Q59:S59))
and fill it down to P82.
- So simple did not think of it since my cells were blank. Thanks!
