i have 3 different discounts eg
company x =40%
company y =50%
company z =60%
if i put x in a cell it will take 40% of the price
if i put z in the same cell it put 60% off
i had a go with IF but i can only use 2 different x or y not all of
them
Andy Notton :(
--
tommytowbar
------------------------------------------------------------------------
tommytowbar's Profile:
http://www.excelforum.com/member.php...o&userid=28219
View this thread:
http://www.excelforum.com/showthread...hreadid=477713