Using IF Formula with multiple columns string

Platform discussions
,
1

Hello Community!

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

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)

2

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
3

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

4

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*

5

@GCavin Thank you very much!! :+1:

1 Like