IF, OR Statement help

[ddub25]

Can anyone help with the construction of this formula? I get unexpected results with anything I've tried.

IF M848="a" or "b" or "c", Then return "X"
IF M848="d" or "e", Then return "Y"
IF not return "Z"

Dan

 

[tc88]

can anyone help with the construction of this formula? I get unexpected results with anything i've tried.

If m848="a" or "b" or "c", then return "x"
if m848="d" or "e", then return "y"
if not return "z"

dan

=if(or(m848="a",m848="b",m848="c"),"x",if(or(m848="d",m848="e"),"y","z"))

 

[Yahya]

try this

=LOOKUP(M848,{"a";"b";"c";"d";"e";"f"},{"X";"X";"X";"Y";"Y";"Z"})

 

[ddub25]

Thanks tc88, just what I wanted.

Dan