Combining an IF Statement with multiplication

[mblackwell]

Greetings,
I am trying to find a formula that will allow me to do the following:

If the value in A1 = 'A' then multiply B1 by .2
If the value in A1 = 'B' then multiply B1 by .15
If the value in A1 = 'C' then multiply B1 by .1

Here is the formula that I have put together, based on my research on this issue, but it is not working.

=IF(A1='A',B1*.02,IF(A1='B',B1*.015,IF(A1='C',B1*.01)))</SPAN>

Any help would be GREATLY appreciated.

 

[Redwolfx]

This formula works for me but instead of single ' use "

 

[mblackwell]

This formula works for me but instead of single ' use "

Hi,
Thanks for your reply. I updated my forumla, and now I get the following error: #NAME?
Is this becuase the A,B, or C is coming over from onther tab via a v-lookup funciton?
-M

 

[Redwolfx]

Everything still works for me. The Vlookup shouldn't matter

 

[mblackwell]

Everything still works for me. The Vlookup shouldn't matter

Thank you! I got it working finally.</SPAN>