|
total value of multiple products
http://www.contextures.com/xlDataVal13.html Check out dependant dropdown lists, It may be what you require -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
thanx bro that worked out perfect....now if i can only get that first part to
work my payroll sheet will be complete......do you have any ideas on how to get that work properly "davesexcel" wrote: http://www.contextures.com/xlDataVal13.html Check out dependant dropdown lists, It may be what you require -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
"thanx bro that worked out perfect....now if i can only get that first part to work my payroll sheet will be complete......do you have any ideas on how to get that work properly"... Can you specify what you require..... -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
I have 3 cells in one row that show codes which represent what was done at a
job. each cell has the same 39 options(the drop downs you helpped me with) i want each code to have a dollar value. (Ie. code 201=$20.00. i want a fourth cell in the same row to total the value of the three cells. so a guy did 3 codes 201,202,203 = $50.00. but he may only do one or two codes also. "davesexcel" wrote: "thanx bro that worked out perfect....now if i can only get that first part to work my payroll sheet will be complete......do you have any ideas on how to get that work properly"... Can you specify what you require..... -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
Dimon1200 Wrote: want each code to have a dollar value. (Ie. code 201=$20.00. i want a fourth cell in the same row to total the value of the three cells. so a guy did 3 codes 201,202,203 = $50.00. but he may only do one or two codes also. [/color] I'll just use these cell references for example purposes: ok lets see if I got this correct If A1=201 then 20 If B1=202 then 20 if C1 = 203 then 20 but if they are all showing then 50 if only two are sowing there values then 40 if one is showing there value then 20 is this correct? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
No. there are 39 codes that each pay a different amount. code 201 pays 20,
but code 202 pays 15, code 203 pays 10(please note these are just example amounts). I just used 50 as an example. it can be multiple totals. Ie. A1=201(=20),B1=202(=25),C1=203(=10) etc... a tech will be able to do up to three codes per job. i need a fourth cell that can give a total dollar value base on the codes selected in those three cells. "davesexcel" wrote: Dimon1200 Wrote: want each code to have a dollar value. (Ie. code 201=$20.00. i want a fourth cell in the same row to total the value of the three cells. so a guy did 3 codes 201,202,203 = $50.00. but he may only do one or two codes also. I'll just use these cell references for example purposes: ok lets see if I got this correct If A1=201 then 20 If B1=202 then 20 if C1 = 203 then 20 but if they are all showing then 50 if only two are sowing there values then 40 if one is showing there value then 20 is this correct? -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 [/color] |
total value of multiple products
I almost have a great idea, we could use a lookup formula for this to work, what do you think of that?! give me some examples of codes and thier values, for each of the three columns, :rolleyes: -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
201=20, 202=15, 203=10, 204=28, 205=35, 206=40, 207=45, 208=50. you will be
the man if you can get this to work......my company just needs to give up and pay for my excell course....ha ha ha "davesexcel" wrote: I almost have a great idea, we could use a lookup formula for this to work, what do you think of that?! give me some examples of codes and thier values, for each of the three columns, :rolleyes: -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
total value of multiple products
Lets start with this, I have attatched a small example; +-------------------------------------------------------------------+ |Filename: dimon1200.zip | |Download: http://www.excelforum.com/attachment.php?postid=4443 | +-------------------------------------------------------------------+ -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
| All times are GMT +1. The time now is 06:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com