Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
characters and values
Hi, I've a question about giving characters a value. Let's say you have your schedule for work in your Excel sheet and ther are several shifts with different time spaces your boss uses to let yo work. These time spaces are used as characters. For instance A is an 8 hour shift and B is a 6 hour shift, while C i just a 2 hour shift. Cell A1 = Monday, Cell A2 = A B1 = Tuesday, B2 = B C1 = Wednesday, C2 = C D1 = Thursday, D2 = A E1 = Friday, E2 = A F1 = Total hours, F2 = sum A2..E2 How can I make sure F2 will tell me I would have worked 32 hours whil still using A, B and C insteas of 8, 4 and 2 ? Thanks, Partysqua -- Partysqua ----------------------------------------------------------------------- Partysquad's Profile: http://www.excelforum.com/member.php...fo&userid=2897 View this thread: http://www.excelforum.com/showthread.php?threadid=49900 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
characters and values
Try
=COUNTIF(A2:E2,"A")*8+COUNTIF(A2:E2,"B")*4+COUNTIF (A2:E2,"C")*2 "Partysquad" wrote in message ... Hi, I've a question about giving characters a value. Let's say you have your schedule for work in your Excel sheet and there are several shifts with different time spaces your boss uses to let you work. These time spaces are used as characters. For instance A is an 8 hour shift and B is a 6 hour shift, while C is just a 2 hour shift. Cell A1 = Monday, Cell A2 = A B1 = Tuesday, B2 = B C1 = Wednesday, C2 = C D1 = Thursday, D2 = A E1 = Friday, E2 = A F1 = Total hours, F2 = sum A2..E2 How can I make sure F2 will tell me I would have worked 32 hours while still using A, B and C insteas of 8, 4 and 2 ? Thanks, Partysquad -- Partysquad ------------------------------------------------------------------------ Partysquad's Profile: http://www.excelforum.com/member.php...o&userid=28970 View this thread: http://www.excelforum.com/showthread...hreadid=499001 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
characters and values
In A3 enter:
=(A2="A")*8+(A2="B")*6+(A2="C")*2 and copy thru E3 In F2 enter: =SUM(A3:E3) -- Gary''s Student "Partysquad" wrote: Hi, I've a question about giving characters a value. Let's say you have your schedule for work in your Excel sheet and there are several shifts with different time spaces your boss uses to let you work. These time spaces are used as characters. For instance A is an 8 hour shift and B is a 6 hour shift, while C is just a 2 hour shift. Cell A1 = Monday, Cell A2 = A B1 = Tuesday, B2 = B C1 = Wednesday, C2 = C D1 = Thursday, D2 = A E1 = Friday, E2 = A F1 = Total hours, F2 = sum A2..E2 How can I make sure F2 will tell me I would have worked 32 hours while still using A, B and C insteas of 8, 4 and 2 ? Thanks, Partysquad -- Partysquad ------------------------------------------------------------------------ Partysquad's Profile: http://www.excelforum.com/member.php...o&userid=28970 View this thread: http://www.excelforum.com/showthread...hreadid=499001 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Odd Characters instead of values | Excel Discussion (Misc queries) | |||
How to add characters to all existing values in a given column | Excel Worksheet Functions | |||
Replace characters from cell values | Excel Programming | |||
Can I have more than 255 characters in Chart "Values" of Excel 2k? | Charts and Charting in Excel | |||
Changing numbers to characters by using range values | Excel Programming |