0.00 showing in an empty cell, I want it blank

In cell D9 I have the the formula

=IF(ISNA(VLOOKUP(C9,Labour!$A$3:$L$12,HLOOKUP(A9,Labour!$B$1:$L$2,2,FALSE),FALSE)),,VLOOKUP(C9,Labour!$A$3:$L$12,HLOOKUP(A9,Labour!$B$1:$L$2,2,FALSE),FALSE))

This is working fine and is a blank cell if A9 and C9 are blank.
If I have used A9 and C9 to give me a result in D9, then delete what is in A9 and C9 I get 0.00 in D9.
I don't want the 0.00, I want a blank cell again.

How can I solve this problem?

Thanks in advance for any help.

Matt

Originally Posted by matt_the_brum

In cell D9 I have the the formula

=IF(ISNA(VLOOKUP(C9,Labour!$A$3:$L$12,HLOOKUP(A9,Labour!$B$1:$L$2,2,FALSE),FALSE)),,VLOOKUP(C9,Labour!$A$3:$L$12,HLOOKUP(A9,Labour!$B$1:$L$2,2,FALSE),FALSE))

This is working fine and is a blank cell if A9 and C9 are blank.
If I have used A9 and C9 to give me a result in D9, then delete what is in A9 and C9 I get 0.00 in D9.
I don't want the 0.00, I want a blank cell again.

How can I solve this problem?

Thanks in advance for any help.

Matt

Rightmouse the cell and set the format to Custom

##,##0.00;-##,##0.00;""

---

Thanks for that.

In the end I found out you can Tools-> Options and take the tick out of the 'Zero' box.