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.

Compound IF function

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 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.

Tips and Tricks

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

IraWatt

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

Workflow.yxmd

carterfleming

That worked! Thanks so much!

IraWatt

Awesome @carterfleming 😄 No worries at all.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703