| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
values not showing for copied formulas
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
values not showing for copied formulas
.. 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
values not showing for copied formulas
Check formatting of the cells, specially any conditional formatting
done. Regards Aqib Rizvi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Having comments copied when using formulas | Excel Worksheet Functions | |||
| How do I stop totals showing from a copied formula? | Excel Discussion (Misc queries) | |||
| Formulas showing as text rather than values | Excel Discussion (Misc queries) | |||
| copied formulas paste as values | Excel Discussion (Misc queries) | |||
| Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions | |||
Hybrid Mode
