values not showing for copied formulas

[Guest]

I am copying an IF formula (=IF(Sheet3!I5<1,I4+1,Sheet3!I5) to other cells.
It copies okay in that if you click a destination cell you can see the
formula and the cell references are correct, however a number of the
destination cells appear blank (in other words no value is showing) even
though the formula is there. Any idea why the values are not showing on some
of the cells? Thanks for any help

 

[Guest]

.. however a number of the destination cells appear blank

(in other words no value is showing)

One guess:

Is the font color set the same as the fill color for those cells (ie
"masked") ?
Make it different ..

---

 

[Aqib Rizvi]

Check formatting of the cells, specially any conditional formatting
done.
Regards
Aqib Rizvi