# Using IF Formula with multiple columns string

Hello Community!

I’m hunting (will continue my search) to create a formula that can help?

I’m stating the logic of what I’m trying to do below so appreciate a formula string that can meet this. Thanks very much! I’ve never done a multiple string formula so I’m improving my formula writing as I build my Monday board. Thank you very much!

IF Column_A is not equal to “X”
(status)

AND/OR?? (not sure which)

If Column_A is not equal to “Y”
(status)

(AND/OR??) not sure which

IF Column_B >0, give me a “1”, otherwise give me a blank
(number)

Hi Rich,

Would be something like this:

``````IF(AND({Column_A}<>"X",{Column_A}<>"Y",{Column_B}>0),"1","0")
``````

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

1 Like

@GCavin Thank you very much Gavin, that worked!…as a follow-on are we able to use “OR” in place of the AND??

Sure, you can replace AND by OR and if you need to combine both, you’ll have to do something like this:

``````IF(AND(OR({Column_A}<>"X",{Column_A}<>"Y"),{Column_B}>0),"1","0")
``````

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at https://mdboosters.com*

@GCavin Thank you very much!!

1 Like