Does Not Equal
katebrew
✭
I have a formula that is working for me....the last part of the formula includes if the "Partner Driven" box is checked.
I now want to run the formula if "Partner Driven" is unchecked - I think it includes <> but I can't figure out where to include the "does not equal.
=COUNTIFS([Event Date]:[Event Date], <=Today(), Theater:Theater, "Americas", [Partner Driven]:[Partner Driven], 1)
Comments
-
To reference an unchecked box, you simply replace the 1 with either 0 (zero) or false. To use the "not equal to" of <>, you would put it in the same placement as =.
This = That
This <> That
