If, and or

[drluke]

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]0
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]26
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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