Lose Zero

**thomas.szwed** · 07-28-2008, 10:10 AM

Hi I have a statement on a cell as follows >

PHP Code:


=VLOOKUP(Data!C7,Data!D6:N19,11)

It looks up a table and if there is a value brings it back otherwise its just displays a zero. I want it to display blank if there is no value rather than the digit zero. How do i do this?

I have tried formatting the cell using a generic function but that doesnt work. Can it be done by an IF statement?

Thanks in Advance

**dominicb** · 07-28-2008, 10:26 AM

Good afternoon thomas.szwed

Does this work OK for you :
=IF(VLOOKUP(Data!C7,Data!D6:N19,11)=0,"",VLOOKUP(Data!C7,Data!D6:N19,11))

HTH

DominicB

**dominicb** · 07-28-2008, 10:30 AM

Hi thomas.szwed

Originally Posted by thomas.szwed

I have tried formatting the cell using a generic function but that doesnt work.

If you'd rather use custom formatting then something like this should do the trick and hide the result, if a zero is returned by the formula :
[>0]#,##0;;;

HTH

DominicB