Another IF

[How_Do_I]

What is wrong with this formula please…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
If A1 = 1, 3, 4, or 6 I want B1 to = “Home” otherwise to = “Away”…
<o> </o>
=IF($A$1={1,3,4,6},"Home","Away")

 

[Jonmo1]

Try

=IF(OR($A$1={1,3,4,6}),"Home","Away")

 

[How_Do_I]

Tried and it is beautiful... thanks Biff.

 

[Jonmo1]

Glad to help, thanks for the feedback Jon

 

[How_Do_I]

Jon... Sorry, I thought Biff had solved that for some reason... Thanks for that and apologises for getting your name wrong.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>