Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
I'm trying to figure out how to leave a cell with a function blank if the
returned value is 0 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
You can't leave the cell empty if it's 0, but you could hide it with formatting
or change the formula so the cell looks empty. =if(yourformula=0,"",yourformula) or Format|conditional formatting cell value is equal to 0 and give it the same font color as fill color (white on white) Or Format|cells|number tab|custom category: 0;-0;;@ Positive;negative;0;text is what each of those element represents. sniper2328 wrote: I'm trying to figure out how to leave a cell with a function blank if the returned value is 0 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMATTING CELLS
Like this:
=IF(your_formula=0,"",your_formula) Hope this helps. Pete On Jan 10, 2:13*am, sniper2328 wrote: I'm trying to figure out how to leave a cell with a function blank if the returned value is 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells | Setting up and Configuration of Excel | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Worksheet Functions | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |