I am trying to diplay the actual value in a
cell if the function is greater than 0.

Try this...

=IF('Sheet1'!K210,'Sheet1'!K21,"")

Note that if the sheet name does not contain spaces or other special
characters then you don't need to include the quotes around the sheet name.
However, including them won't hurt anything other than to make the formula a
bit harder to read.

=IF(Sheet1!K210,Sheet1!K21,"")

--
Biff
Microsoft Excel MVP


"Parker63385" wrote in message
...
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