Forum Discussion

lhunter700's avatar
lhunter700
Copper Contributor
May 03, 2022
Solved

Formula Trouble with Blank Cells

I am trying to do something which seems simple, but having issues...

 

In column B I am trying to enter a value of 5 anytime Column A (the result of which is generated by a formula) has a number greater than 0 in it, otherwise leave it as blank.

 

I'm using the formula:  IF(A1>0,"5","")

 

This works fine if A has a 0 or a  # but sometimes A is blank.  When it is blank, i still get a value of 5 in column B.  If i change the formula for A to force the blank to be a 0, it still doesn't work (guess because it is not a true 0).

 

I can filter column A by blanks and then manually adjust column B for these cases but trying to find a formulaic solution.

 

Any thoughts?

Thanks,

Lisa

 

  • lhunter700 

    If result in A1 is generated by formula the cell can't be blank. Most probably formula returns empty string or some number.

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

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    lhunter700 

    If result in A1 is generated by formula the cell can't be blank. Most probably formula returns empty string or some number.

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

Resources