3 different discounts help !

[tommytowbar]

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

[George Nicholson]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(cell="x",40%,IF(cell="y",50%,IF(cell="z",60%,0)))

clearly you need to incorporate within your formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tommytowbar" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[tommytowbar]

excellent work !

thanks for that

no more sleepless nights

[Random Poster]

tommytowbar <[email protected]>
wrote in news:[email protected]:

>
> excellent work !
>
> thanks for that
>
> no more sleepless nights
>
>



I'll echo George's previous comments. Maintaining the discounts in a
separate table is the way to go.

There are a few ways to get the needed discount from the table. I prefer
INDEX & MATCH, VLOOKUP is also popular.


-RP