need help with formula

[Brian]

in cell a1 i have one of four letters a b c or d
and in cell b1 i want the following:

if cell a1 = a then return "days"
if cell a1 = b then return "days"
"" = c then return "Evenings"
"" = d then return "Evenings"

what function do I use for this and how.

Thank You
Brian

 

[Don Guillett]

try
=IF(OR(H6="a",H6="b"),"day",IF(OR(H6="c",H6="d"),"Evenings",""))

 

[Brian]

Thank You for your Help,

Brian

-----Original Message-----
try
=IF(OR(H6="a",H6="b"),"day",IF(OR (H6="c",H6="d"),"Evenings",""))




.

 

[Ron Rosenfeld]

in cell a1 i have one of four letters a b c or d
and in cell b1 i want the following:

if cell a1 = a then return "days"
if cell a1 = b then return "days"
"" = c then return "Evenings"
"" = d then return "Evenings"

what function do I use for this and how.

Thank You
Brian

Another way:

=CHOOSE((CODE(A1)-95)/2,"days","Evenings")


--ron