Return empty after looking for two values

[ckroon]

I have this formula:
=IF(CN8="","",1)
Which returns a 1 if CN8 is empty

I want to add =0 as well so it returns as empty if CN8 has a 0, or is empty

How do I add that OR statement to that formula?

 

[VoG]

Try

=IF(OR(ISBLANK(CN8),CN8=0),"",1)

 

[ckroon]

Cool

Now when I copy down that formula in the cells below, I need the return value of 1 to increment along with the cell names.

Either that or I have to enter 2, 3, 4, 5, all the way down to kingdom come..

 

[VoG]

You may need to use an offset with this

=IF(OR(ISBLANK(CN8),CN8=0),"",ROW())

 

[ckroon]

Graci!