Formulating one cell, depending on another

[DLaceyUSA]

(my apologies if the title isn't appropriate)

I am creating a sheet with the following information:

CELL G (choose OWN, TOUCH, REFERRAL)
CELL I contains $$
CELL L is to contain $$figure of either 40% or 20% or 10% of CELL I, depending on choice in CELL G

So the results would be:

Please Login or Register  to view this content.

I've tried a couple of examples given here, such as combining more than one function in the IF statement.. but I'm not coming up with anything.

Thank you for helping a newbie.

~L~

[Special-K]

=if(g2="own",40%,if(g2="touch",20%,if(g2="referral",10%,"error")))

[shg]

... or =INDEX({0.4,0.2,0.1}, MATCH(G1, {"own","touch","referral"}, 0)) * I1