If, and or

[drluke]

	A	B
1		10
2	0
3	26

<tbody>
</tbody>

A1 = blank (but not empty as it has " ")
B1 = number

A2 = 0
B2 = empty

A3 = 26
B3 = empty

I am trying to write IF statement: if A1, A2 etc is a number and =0 OR B1, B2 etc is blank (empty) then delete row.

In table above I should have C1 = Keep C2 = Delete C3 = Keep

I am tying =IF(AND(OR(ISNUMBER(A1),A1=0,ISBLANK(B1)),"Keep","Delete"), however my results are the other way around. Don't know how to correct.

 

[wideboydixon]

Just switch the keep/delete around

=IF(OR(AND(ISNUMBER(A1),A1=0),ISBLANK(B1)),"Delete","Keep")

WBD

 

[drluke]

If I do that, then I get 'Delete' in C2 whereas I should have 'Keep'

 

[wideboydixon]

Not according to your original post:

if A1, A2 etc is a number and =0 OR B1, B2 etc is blank (empty) then delete row

WBD