HOW TO ENTER A BLANK IN WORKSHEET FUNCTION

T

T2

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 %.
 
C

crowzhome

Hi, I had the same issue not too long back and this is what I used.

=+IF(A1>0,A1,"")

See if this works for you.
 
Top