(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:

CELL G             CELL I          CELL L

OWN                200.00          80.00    (40% of CELL I)
TOUCH              200.00         40.00    (20% of CELL I)
REFERRAL          200.00          20.00    (10% of CELL I)

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~