IF function used in a range

[Besh]

If f5 to f8 has an "x" I want true to be "1" and false to be blank.

*I don't need all four cells to have an "x" to return a "1", just any or all of them within the range.

Thanks, Besh

 

[Aladin Akyurek]

If f5 to f8 has an "x" I want true to be "1" and false to be blank.

*I don't need all four cells to have an "x" to return a "1", just any or all of them within the range.

Thanks, Besh

Try...

=IF(COUNTIF(F5:F8,"X"),1,"")

 

[Besh]

Works!

Thank you, Besh

 

[Aladin Akyurek]

Works!

Thank you, Besh

You are welcome. Thanks for providing feedback.