| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on excel formula
is possible to write a formula to count the number of hours worked in each
dept. the number of hours worked in each dept can vary from 1 to 7 vice versa. eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3 to return with the value 4 and a2 and if a1 is cash then a2 to return with the value 8 and if a1 is stock then a3 to reurn with the value 8. can anyone help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help on excel formula
some questions
is the data in a1 exactly like you type ie 3space"cash"space4space"stock" a formula can be built to extract the hours to a2 and a3 ,but then i get lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4+3? -- paul remove nospam for email addy! "cj" wrote: is possible to write a formula to count the number of hours worked in each dept. the number of hours worked in each dept can vary from 1 to 7 vice versa. eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3 to return with the value 4 and a2 and if a1 is cash then a2 to return with the value 8 and if a1 is stock then a3 to reurn with the value 8. can anyone help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help on excel formula
no, the data in a1 should read 3cash 4stock and if a1 is "cash" , i want a2
to return with value of 8 and if a1 is "stock" , i want a3 to return with value of 8. "paul" wrote: some questions is the data in a1 exactly like you type ie 3space"cash"space4space"stock" a formula can be built to extract the hours to a2 and a3 ,but then i get lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4+3? -- paul remove nospam for email addy! "cj" wrote: is possible to write a formula to count the number of hours worked in each dept. the number of hours worked in each dept can vary from 1 to 7 vice versa. eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3 to return with the value 4 and a2 and if a1 is cash then a2 to return with the value 8 and if a1 is stock then a3 to reurn with the value 8. can anyone help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help on excel formula
aha if 3cash4stock you want a2 to show 3 and a3 to show 4 if a1 is cash a2= 8
if a1 stock a3 8???? -- paul remove nospam for email addy! "cj" wrote: no, the data in a1 should read 3cash 4stock and if a1 is "cash" , i want a2 to return with value of 8 and if a1 is "stock" , i want a3 to return with value of 8. "paul" wrote: some questions is the data in a1 exactly like you type ie 3space"cash"space4space"stock" a formula can be built to extract the hours to a2 and a3 ,but then i get lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4+3? -- paul remove nospam for email addy! "cj" wrote: is possible to write a formula to count the number of hours worked in each dept. the number of hours worked in each dept can vary from 1 to 7 vice versa. eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3 to return with the value 4 and a2 and if a1 is cash then a2 to return with the value 8 and if a1 is stock then a3 to reurn with the value 8. can anyone help |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help on excel formula
ahhh I see you started a new thread..
-- paul remove nospam for email addy! "cj" wrote: no, the data in a1 should read 3cash 4stock and if a1 is "cash" , i want a2 to return with value of 8 and if a1 is "stock" , i want a3 to return with value of 8. "paul" wrote: some questions is the data in a1 exactly like you type ie 3space"cash"space4space"stock" a formula can be built to extract the hours to a2 and a3 ,but then i get lost,what is the logic that says you need 8 =cash and 8 =stock or 8 from 4+3? -- paul remove nospam for email addy! "cj" wrote: is possible to write a formula to count the number of hours worked in each dept. the number of hours worked in each dept can vary from 1 to 7 vice versa. eg) if a1 is 3 cash 4 stock , i want a2 to return with the value 3 and a3 to return with the value 4 and a2 and if a1 is cash then a2 to return with the value 8 and if a1 is stock then a3 to reurn with the value 8. can anyone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
