Hello -

I am looking for a formula that will do:

If any cell, C5 through C34, equals "x", then 1, otherwise 0.

I cannot seem to figure out an easy way to do this, without listing every cell in an OR statement within an IF statement.

Any help would be appreciated!