Thread: If Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Parker63385 Parker63385 is offline
external usenet poster
 
Posts: 1
Default If Function

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