Hope this helps!

=IF(B1="D",B4*1,IF(B1="C",B4*2,IF(B1="B",B4*3,IF(B 1="A",B4*4,0))))

"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