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

If this post helps click Yes
---------------
Jacob Skaria


"lisab" wrote:

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!