Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3 different discounts help !
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 |
#2
|
|||
|
|||
3 different discounts help !
=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" 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 |
#3
|
|||
|
|||
3 different discounts help !
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 |
#4
|
|||
|
|||
3 different discounts help !
excellent work ! thanks for that no more sleepless nights -- tommytowbar ------------------------------------------------------------------------ tommytowbar's Profile: http://www.excelforum.com/member.php...o&userid=28219 View this thread: http://www.excelforum.com/showthread...hreadid=477713 |
#5
|
|||
|
|||
3 different discounts help !
tommytowbar
wrote in : 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate discounts within a pricelist | Excel Discussion (Misc queries) | |||
limit a value using discounts | Excel Worksheet Functions | |||
Limit a sum using discounts | Excel Discussion (Misc queries) |