=if(or(a1="a",a1="b"),5,if(a1="c",10,if(a1="m",15, "error code")))

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"littlebit" wrote in message
...
I'm tryng to write a statement for the following:
if a or b are typed in cell than 5 is the multiplier, if c is typed in
cell
than 10 is multiplier, if m is typed in cell than 15 is multiplier,
anything
else would give an error code. help appreciated. using excel 2000.