Thread: HOW TO ENTER A BLANK IN WORKSHEET FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T2 T2 is offline
external usenet poster
  
Posts: 3
Default HOW TO ENTER A BLANK IN WORKSHEET FUNCTION
Help!
I need a Blank cell when A1 is NOT 0 for Excel charting. I have tried the
following worksheet functions
=IF(isnumber(A1),A1,"")
=IF(isnumber(A1),A1," ")
but ended up with 0 in cell. Btw, A1 is in %.
Reply With QuoteReply With Quote