Thanks for everyone's help! I really appreciate it!

Michelle

and to the poster (Jerry) that asked about when none of the conditions are
true..in this case it woulsd always be a, b, c or d.

Thanks again!

"MichelleD" wrote:

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