values not showing for copied formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
.. however a number of the destination cells appear blank
(in other words no value is showing)
Click to expand...

One guess:

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

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