Blank Cell When Formula Result Is Zero

[corndale]

I have the following formulas in an Excel worksheet: =D10-G10, and ='Payments Held'!F10. The cells are formatted for Currency. When there are no values is the cells related to the formula (D10 & G10, for instance), the cell displays a value of $0.00. For appearance sake, I would like the cell to be blank instead of $0.00. How can I accomplish this? Thanks.

[Audiojoe]

Hi there,

You could set the font colour to white and conditionally format the cells to turn black if their value is more than 0.000000001

Audiojoe

[dk]

Try this:-

=IF('Payments Held'!F10=0,"",'Payments Held'!F10)

HTH,
Dan

[stone]

sELECT ALL YOUR cells, goto Format->conditional formatting.

condition1-> cell value is->equalto->$0,00
then select format->pattern and select black
push okey.

BK
Stulli

[inarbeth]

Why not us Tools, Options, select View tab and uncheck zero values?

I use the following macro attached to a toolbar button to toggle the zero values:

Sub ZeroValues()
ActiveWindow.DisplayZeros = Not ActiveWindow.DisplayZeros
End Sub


[ This Message was edited by: inarbeth on 2002-05-14 06:11 ]

[Aladin Akyurek]

Custom format the formula cell as:

[=0]""

Aladin

[WayneTN]

Would it be acceptable to use the Accounting format (without the $) in this cell instead of the Currency format? This way you would only have a "-" instead of "$0.00".

[corndale]

I would like to thank everyone for your replies. I found stone's suggestion to be the easiest to implement. However, I will also experiment with dk's & inarbeth's suggestions. I think Aladin Akyurek's suggestion is similiar to stone's.

[Rick M]

You may try selecting the $0.00 cell
Go to Tools>Options>view and click OFF the zero values. that will leave the cell blank.

[Aladin Akyurek]

I think Aladin Akyurek's suggestion is similiar to stone's.


I think that's about right in effect. Custom formatting can be less resource demanding and also faster in processing time.