hi!

I would like to create a series of discount functions in excel based on
a certain product. For example, I am selling 10 brands and each of these
brands has a different discount.
Say that I prepare an economical offer in excel, I'd like a function
that as soon as I digit the name of that certain brand, the cost of
that item, it gives me at once the rate of discount I have for that
specific brand. Does this makes sense?
Say i am selling a sony camcorder, I know that with sony I have 50% of
discount, I would like that when I write any number (the cost of the
item) under the name sony (which excel should recognize) then it would
apply at once a discount.
I know it's quite complicated but I hope someone wll help me thanks!!


--
number


------------------------------------------------------------------------
number's Profile: http://www.excelforum.com/member.php...o&userid=24949
View this thread: http://www.excelforum.com/showthread...hreadid=384832