If Statement for 4 columns

Josiah Simmons

Is it possible to make a if statement that references four columns to make a decision?

I'm trying to make a if statement that basically will check if someone said yes to each choice for said animal. If they did I want to the decision column to say "Send Info", If not "Don't Send".

L_123

=if(or(dogs1 = "yes", Cats1 = "yes", birds1 = "yes", horses1 = "yes"),"Send Info", "Don't Send")

Above is the one of the more basic methods of using this type of logic. You can also combine different formulas to perform this task a bit more optimized.

=if(countif(dogs1:horses1,"yes")>0,"Send Info", "Don't Send")

As an example.