Formatting

  • Thread starter Thread starter Cindy Jordan
  • Start date Start date
C

Cindy Jordan

I would like to formatt cells that contain formula's that
equal 0 to show as blank.

I have used if(isblank(A1+A2)=true,"",A1+A2).

The problem is when you try to sum several of those
formulas together you get an error #value!. I have tried
to use if(iserror(),"",xx) but is one cell has a value and
the others dont it doesnt add the cell with the value.

If there is a way to just format a 0 cell to show nothing
that would be the best but any help will be appreciated.

Thanks in advance. Cindy.
 
Sorry. That should have been General;-0; otherwise your negatives will
show as positive (doh). FYI, the layout of the format is

positve number format ; negative number format ; zero value format

Andy
 
Cindy Jordan said:
I would like to formatt cells that contain formula's that
equal 0 to show as blank.

I have used if(isblank(A1+A2)=true,"",A1+A2).

The problem is when you try to sum several of those
formulas together you get an error #value!. I have tried
to use if(iserror(),"",xx) but is one cell has a value and
the others dont it doesnt add the cell with the value.

If there is a way to just format a 0 cell to show nothing
that would be the best but any help will be appreciated.

Thanks in advance. Cindy.
Click to expand...

Why not just turn off display of zero values?
Tools > Options > View tab
Uncheck "Zero Values".
 
turning off the zero value displays as $ - When you
formatt the cell of dollar.

I found the right custom formatt.

Thanks for the help.
 
can you tell me how i can formay my computer .i have alot of junk in it and i want to stsrt over and clean it all out i ope you can help me thank you karen
 
This is really not the forum for this question but it is sometimes just
easier to buy a new computer. <G>

--
Don Guillett
SalesAid Software
(e-mail address removed)
karen said:
can you tell me how i can formay my computer .i have alot of junk in it
Click to expand...
and i want to stsrt over and clean it all out i ope you can help me thank
you
karen
 
Back
Top