"If" function and blank cells

[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!

 

[Jacob Skaria]

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

If this post helps click Yes

 

[T. Valko]

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

Try this...

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

 

[cm]

try:

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

 

[RagDyeR]

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!

 

[David Biddulph]

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