show a zero instead of blank if a particular cell is blank

**jeff dorlaque** · 08-21-2012, 09:12 PM

If Cell D11 is blank I need AD11 to show $0.00, If there is anything in D11 i want AD11 to show that value.
The formula I used is =IF(D11="",0,D11) If I enter a value in D11 AD11 does show that value , but if I clear D11 AD11 clears as well and does not show $0.00.

Please help

**lzuke** · 08-21-2012, 09:25 PM

How about?
=IF(D11<0.01,0,D11)

**vlady** · 08-21-2012, 09:32 PM

you formula should work otherwise you used the space bar---that is not "" for space it's " "

if you can't avoid using space bar to delete the contents of that cell you can use the isnumber()

=IF(ISNUMBER(D11),D11,0)

**Teethless mama** · 08-21-2012, 09:43 PM

Very simple formula:

=D11

**lzuke** · 08-21-2012, 09:59 PM

Ha! So simple.

**vlady** · 08-21-2012, 10:02 PM

@ teethles mama the OP's formula should work but he/she said it's not working, i think the op is using "space bar " to delete entries so that's space you can try it in your formula
press space bar to delete D11 contents then you'll not receive 0 as return value.

**jeff dorlaque** · 08-22-2012, 12:25 AM

I am pressing spacebar to clear D11 and when i do that it causes AD11 to clear as well and not return the $0.00 i am looking for. I know i can press delete on D11which will clear it and it will cause AD11 to show $0.00 however alot of people are going to be using this sheet and I know some people will press space bar which will cause an error and the whole sheet will not work. Just trying to fool proof it.