HOW TO ENTER A BLANK IN WORKSHEET FUNCTION

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 %.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Count based on string in cell 2
Scrabble Value calculation for Welsh words 0
Search Entire Sheet instead of 1? 4
How to use the IF function to resolved more than one creteria 4
Blank cell from another page within a worksheet? 9
I need a cell to be blank. 4
How do I put a blank value in a cell not using "" in a formula 2

Back
Top