ExcelBanter - HOW TO ENTER A BLANK IN WORKSHEET FUNCTION

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW TO ENTER A BLANK IN WORKSHEET FUNCTION (https://www.excelbanter.com/excel-worksheet-functions/122763-how-enter-blank-worksheet-function.html)

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

crowzhome

HOW TO ENTER A BLANK IN WORKSHEET FUNCTION

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

=+IF(A10,A1,"")

See if this works for you.

"T2" wrote:

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

JLatham

HOW TO ENTER A BLANK IN WORKSHEET FUNCTION

Try
=IF(A1<=0,"",A1)

"T2" wrote:

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

All times are GMT +1. The time now is 02:54 AM.