.. 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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeanne L" wrote:
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