Zero to appear as blank

[Guest]

I have a VLOOKUP formula below. When the value is zero, I want the result to be blank. What do I do.

=IF(A10="","",VLOOKUP(A10,detail,2))

Thnx
Prakash.....

 

[Dave Peterson]

=if(a10="","",if(vlookup(a10,detail,2)=0,"",vlookup(a10,detail,2)))

 

[Rollin_Again]

In addition to modifying your formula as Dave suggested, you can do the
following two things to suppress zeroes.

You can set a custom number format in order to suppress zeros for
certain cells. To do this, select all the cells on the sheet that you
would like to suppress zero values and right-click them and choose
"Format Cells." Choose the Tab labeled "Number" and select "Custom"
from list. Then in the textbox labeled "Type" enter the following
format *0;-0;;@ *


If you want to suppress all zeroes on the entire sheet you can change
the sheet's view options. To do this, click *TOOLS --> OPTIONS -->
VIEW* and uncheck the zeroes values checkbox.


Rollin