"If" function and blank cells

  • Thread starter Thread starter lisab
  • Start date Start date
L

lisab

I'm trying to create an If function where if the cell is equal to 0, then the
cell is populated with 1. However, I've discovered that the formula is not
ignoring blank cells. Can I add a function for it to ignore blank cells?
This is what I have so far:

=IF('Performance Analysis'!J36 =0,1,"")

Any help is appreciated!
 
Try
=IF(AND('Performance Analysis'!J36<>"",'Performance Analysis'!J36=0),1,"")

If this post helps click Yes
 
=IF('Performance Analysis'!J36 =0,1,"")

Try this...

=IF('Performance Analysis'!J36="","",IF('Performance Analysis'!J36=0,1,""))
 
Try:

=IF(AND(ISNUMBER(J36),J36=0),1,"")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I'm trying to create an If function where if the cell is equal to 0, then
the
cell is populated with 1. However, I've discovered that the formula is not
ignoring blank cells. Can I add a function for it to ignore blank cells?
This is what I have so far:

=IF('Performance Analysis'!J36 =0,1,"")

Any help is appreciated!
 
I doubt whether you need the "=true".
ISBLANK returns a boolean TRUE or FALSE; comparing it with TRUE will return
TRUE or FALSE respectively.

Remember, of course, that ISBLANK will not be true if the cell contains an
empty text string "".
 
Back
Top