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 |
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 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 |
3 different discounts help !
excellent work ! thanks for that no more sleepless nights :cool: -- tommytowbar ------------------------------------------------------------------------ tommytowbar's Profile: http://www.excelforum.com/member.php...o&userid=28219 View this thread: http://www.excelforum.com/showthread...hreadid=477713 |
3 different discounts help !
tommytowbar
wrote in : excellent work ! thanks for that no more sleepless nights :cool: 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 |
All times are GMT +1. The time now is 03:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com