No double quotes..Double quote will treat that as a text string

=IF('Sheet 1'!K21=0,"",'Sheet 1'!K21)

If this post helps click Yes
---------------
Jacob Skaria


"Parker63385" wrote:

I am trying to diplay the actual value in a cell if the function is greater
than 0. But I get the sheet name and cell (exactley what is in the " ")
instead of the value, if 0 i get blank (that part works). any help is
appreciated.
Here is what I have:

=IF('Sheet 1'!K21=0,"'","'Sheet 1'!K21")

thanks in advance
JP