| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if...or...Function
I need to create a function that says:
If cell x is either 2,4,6,or 8, then type 'blue' in cell y and if cell x is either 1,3,5 or 7, then enter 'yellow' in cell y and if cell x is either 10,12,14,or 16, then enter 'green' in cell y etc.... |
|
#2
|
|||
|
|||
|
If vba use SELECT CASE
select case =cell x case =1,3,5,7: mc=yellow case=2,etc case else end select cell y=mc -- Don Guillett SalesAid Software "Mgt" wrote in message ... I need to create a function that says: If cell x is either 2,4,6,or 8, then type 'blue' in cell y and if cell x is either 1,3,5 or 7, then enter 'yellow' in cell y and if cell x is either 10,12,14,or 16, then enter 'green' in cell y etc.... |
|
#3
|
|||
|
|||
|
I guess I need more info (sorry)
what is vba? how do I select case--I can't find this option in Excel.... "Don Guillett" wrote: If vba use SELECT CASE select case =cell x case =1,3,5,7: mc=yellow case=2,etc case else end select cell y=mc -- Don Guillett SalesAid Software "Mgt" wrote in message ... I need to create a function that says: If cell x is either 2,4,6,or 8, then type 'blue' in cell y and if cell x is either 1,3,5 or 7, then enter 'yellow' in cell y and if cell x is either 10,12,14,or 16, then enter 'green' in cell y etc.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Linear Mode
