a formula
=LOOKUP(B1,{"a","b","c","d"},{4,3,2,1})*B4
--
Don Guillett
SalesAid Software

"MichelleD" wrote in message
...
Hi,

I am trying to create a formula that does the following...

if b1 is D, then multiply b4 x 1
if b1 is C, then multiply b4 x 2
if b1 is B, then multiple b4 x 3
if b1 is A, then multiply b4 X 4

Can anyone help me creat this formula??

Thanks,
Michelle