Put your discounts in a separate table and use Vlookup to 'pull' the correct
discount value.

Hey, you *know* there will be more than 3 someday soon, and this way you
only need to make an addition to the table.
Not to mention that changing existing discount rates couldn't be simpler.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"tommytowbar"
wrote in message
...

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