software

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:

www.contextures.com/xlDataVal13.html

Check out dependant dropdown lists, It may be what you require--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519591thanx 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

quot;davesexcelquot; wrote:

gt;
gt; www.contextures.com/xlDataVal13.html
gt;
gt; Check out dependant dropdown lists, It may be what you require
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519591
gt;
gt;


quot;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 properlyquot;...

Can you specify what you require.....--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519591I 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.

quot;davesexcelquot; wrote:

gt;
gt; quot;thanx bro that worked out perfect....now if i can only get that first
gt; part to
gt; work my payroll sheet will be complete......do you have any ideas on
gt; how to
gt; get that work properlyquot;...
gt;
gt; Can you specify what you require.....
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519591
gt;
gt;


Dimon1200 Wrote:
gt;
gt; want each code to have a dollar value. (Ie. code 201=$20.00. i want a
gt; fourth
gt; cell in the same row to total the value of the three cells. so a guy
gt; did 3
gt; codes 201,202,203 = $50.00. but he may only do one or two codes also.
gt; gt;[/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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519591No. 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.

quot;davesexcelquot; wrote:

gt;
gt; Dimon1200 Wrote:
gt; gt;
gt; gt; want each code to have a dollar value. (Ie. code 201=$20.00. i want a
gt; gt; fourth
gt; gt; cell in the same row to total the value of the three cells. so a guy
gt; gt; did 3
gt; gt; codes 201,202,203 = $50.00. but he may only do one or two codes also.
gt; gt; gt;
gt;
gt;
gt; I'll just use these cell references for example purposes:
gt; ok lets see if I got this correct
gt; If A1=201 then 20
gt; If B1=202 then 20
gt; if C1 = 203 then 20
gt; but if they are all showing then 50
gt; if only two are sowing there values then 40
gt; if one is showing there value then 20
gt; is this correct?
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519591
gt;
gt;[/color]


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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519591201=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

quot;davesexcelquot; wrote:

gt;
gt; I almost have a great idea, we could use a lookup formula for this to
gt; work, what do you think of that?!
gt; give me some examples of codes and thier values, for each of the three
gt; columns,
gt;
gt;
gt; --
gt; davesexcel
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=519591
gt;
gt;


Lets start with this,
I have attatched a small example; -------------------------------------------------------------------
|Filename: dimon1200.zip |
|Download: www.excelforum.com/attachment.php?postid=4443 |
-------------------------------------------------------------------

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=519591