| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I apply formula to entire column
When I apply the formula to the entire column (a running total that is
updated everyday) "0" appear in all the ensuing cells that have not yet been used. I would like to be able to apply the formula to current and future entries without Exel placing those "0" in the cells not yet used. Does that make any sense? Thanks Stephan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I apply formula to entire column
Hi Stephan,
If I understand correctly, you just need to encapsulate your formula into an If() function : = If(yourformula=0,"",yourformula) HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I apply formula to entire column
Tools-Options- on the veiw tab deselect "Zero Values"
Mike Rogers "Stephan" wrote: When I apply the formula to the entire column (a running total that is updated everyday) "0" appear in all the ensuing cells that have not yet been used. I would like to be able to apply the formula to current and future entries without Exel placing those "0" in the cells not yet used. Does that make any sense? Thanks Stephan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| I want to apply a formula to an entire column. | Excel Discussion (Misc queries) | |||
| How do I apply a function to an entire column? | New Users to Excel | |||
| How do I create a formula for an entire column | New Users to Excel | |||
Linear Mode
