| 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 |
| 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 | |||
Threaded Mode
