Compound IF function

[carterfleming]

I'm trying to write an IF statement in a Filter tool that needs to look at data in two columns. It should go something like this:

IF (column A) contains "AC" AND IF (column B) contains a number, then remove from data. 

Need some info on how to both write a compound IF statement and have the second part of that statement look for any number.

[IraWatt · Accepted solution]

Hey @carterfleming,

Heres one way of doing this:

In the filter you dont need IF's you just need the logical expression to return true or false. I used regex match which only matches if all the characters are numbers and returns true.

Any questions or issues please ask :)
HTH!
Ira

[carterfleming]

That worked! Thanks so much!

[IraWatt]

Awesome @carterfleming 😄 No worries at all.