Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF TYPE FUNCTION
I have office student 2003 excell. My problem is getting a single cell to be
examined for content and based what is in there will do one of many things. ie cell 1 has "A" value and does "z work", if cell 1 has "B" value and does "y work", if cell 1 has "C" value and does "x work" etc. "IF" statement will only allow me to do a true or false with an excution. "OR" state will only allow me to check the cell but not perform something else. -- Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF TYPE FUNCTION
Steve wrote:
I have office student 2003 excell. My problem is getting a single cell to be examined for content and based what is in there will do one of many things. ie cell 1 has "A" value and does "z work", if cell 1 has "B" value and does "y work", if cell 1 has "C" value and does "x work" etc. "IF" statement will only allow me to do a true or false with an excution. "OR" state will only allow me to check the cell but not perform something else. One way is to use nested IF statements: =IF(A1="A",[z work],IF(A1="B",[y work],IF(A1="C",[x work],[default work]))) This construct has its limitations and can get a little tedious to code and debug. Depending on your actual situation, there might be a better way. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF TYPE FUNCTION
-- Thank you that looks like my answer. I'll have to check this out in the morning. You indicate that there maybe a different way what is it? Steve "smartin" wrote: Steve wrote: I have office student 2003 excell. My problem is getting a single cell to be examined for content and based what is in there will do one of many things. ie cell 1 has "A" value and does "z work", if cell 1 has "B" value and does "y work", if cell 1 has "C" value and does "x work" etc. "IF" statement will only allow me to do a true or false with an excution. "OR" state will only allow me to check the cell but not perform something else. One way is to use nested IF statements: =IF(A1="A",[z work],IF(A1="B",[y work],IF(A1="C",[x work],[default work]))) This construct has its limitations and can get a little tedious to code and debug. Depending on your actual situation, there might be a better way. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF TYPE FUNCTION
Not to be elusive, but it depends. Describe your real problem in more
detail and we can explore the options. Steve wrote: -- Thank you that looks like my answer. I'll have to check this out in the morning. You indicate that there maybe a different way what is it? Steve "smartin" wrote: Steve wrote: I have office student 2003 excell. My problem is getting a single cell to be examined for content and based what is in there will do one of many things. ie cell 1 has "A" value and does "z work", if cell 1 has "B" value and does "y work", if cell 1 has "C" value and does "x work" etc. "IF" statement will only allow me to do a true or false with an excution. "OR" state will only allow me to check the cell but not perform something else. One way is to use nested IF statements: =IF(A1="A",[z work],IF(A1="B",[y work],IF(A1="C",[x work],[default work]))) This construct has its limitations and can get a little tedious to code and debug. Depending on your actual situation, there might be a better way. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF TYPE FUNCTION
If you have many possibilities, you may want to go with a VLOOKUP.
Create a table with your value list in, say, Sheet2, column A and your work result in column B. in your desired result cell, type =VLOOKUP(A2,Sheet2!A:B,2,0) to return the B value. "Steve" wrote: I have office student 2003 excell. My problem is getting a single cell to be examined for content and based what is in there will do one of many things. ie cell 1 has "A" value and does "z work", if cell 1 has "B" value and does "y work", if cell 1 has "C" value and does "x work" etc. "IF" statement will only allow me to do a true or false with an excution. "OR" state will only allow me to check the cell but not perform something else. -- Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
some type of IF function | Excel Worksheet Functions | |||
TYPE function | Excel Worksheet Functions | |||
NVL type function | Excel Worksheet Functions | |||
Help with TYPE function | Excel Discussion (Misc queries) | |||
I need a productif type function | Excel Discussion (Misc queries) |