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

1. ## show a zero instead of blank if a particular cell is blank

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.

2. ## Re: show a zero instead of blank if a particular cell is blank

=IF(D11<0.01,0,D11)

3. ## Re: show a zero instead of blank if a particular cell is blank

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)

4. ## Re: show a zero instead of blank if a particular cell is blank

Very simple formula:

=D11

5. ## Re: show a zero instead of blank if a particular cell is blank

Ha! So simple.

6. ## Re: show a zero instead of blank if a particular cell is blank

@ 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.

7. ## Re: show a zero instead of blank if a particular cell is blank

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.

8. ## Re: show a zero instead of blank if a particular cell is blank

Then look at post #3. this should give you what you want.if you have tried that.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1