Since you asked for an "error code", try this for brevity:

=VLOOKUP(A1,{"a",5;"b",5;"c",10;"m",15},2,0)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"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.