(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~
Bookmarks