If formula question

Jillian M

I have 3 cells in a row that I need a cell to report back "yes" if all 3 cells have the word "Pass" in them. I'm using this formula but it's not working...suggestions?

=IF([Pass/Fail]@row = "Pass", [Intro Pass/Fail]@row = "Pass", [RCA Pass/Fail]@row = "Pass", "YES") states "Incorrect Argument"

Thanks!!

DKazatsky2

Hi @Jillian M ,

If you don't want to multiple "IF" statements, yo can also use "AND" inside the main "IF" statement.

=IF(AND([Pass/Fail]@row = "Pass", [Intro Pass/Fail]@row = "Pass", [RCA Pass/Fail]@row = "Pass"), "Yes")

Hope that helps,

Dave

Jillian M

I figured it out! Had to make all 3 separate "IF" statements within the formula :-)

DKazatsky2

Hi @Jillian M ,

If you don't want to multiple "IF" statements, yo can also use "AND" inside the main "IF" statement.

=IF(AND([Pass/Fail]@row = "Pass", [Intro Pass/Fail]@row = "Pass", [RCA Pass/Fail]@row = "Pass"), "Yes")

Hope that helps,

Dave

Jillian M

Perfect! Thank you for the tip!!