| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
total value of multiple products
i have a payroll grid. it has 3 cells with drop downs that have 39 options.
there codes for payments. i need a fourth cell to show a total dollor amount based of the codes selected. separate question. i have a list of cells with the same four options (Job Types.ie service call, new connect...) i want to limit the cells mentioned before so that payment codes that do not pertain to the job type can not be selected. i dont know if that makes any sence, but if you have any questions please email me at: |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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] |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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,  -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=519591 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| @SUM Total Changes | Excel Worksheet Functions | |||
| How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
| How can I get a total across multiple spreadsheets? | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Linear Mode
