| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with forumula to change text cell
I have a column Q - that has state abbreviations. Trying to have a
forumula that changes those to a region. Can't get this to work. Does the IF function not support OR? If I dont use the or, works fine. =IF(Q:Q="CA","California",IF((Q:Q="WA" Or "OR"),"Pacific","Other") |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with forumula to change text cell
Use this where you want it to be. =IF(Q:Q="CA","California",IF(OR(Q:Q="WA",Q:Q="OR") ,"Pacific","Other")) BerkshireGuy Wrote: I have a column Q - that has state abbreviations. Trying to have a forumula that changes those to a region. Can't get this to work. Does the IF function not support OR? If I dont use the or, works fine. =IF(Q:Q="CA","California",IF((Q:Q="WA" Or "OR"),"Pacific","Other" -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=52941 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does forumula show in cell instead of formula result? | Excel Worksheet Functions | |||
| Autofill cell reference forumula not working | Excel Worksheet Functions | |||
| Retreive part of the value from each cell - Macor and/or forumula | Excel Discussion (Misc queries) | |||
| Is there a forumula that uses colors instead of cell #'s? | Excel Discussion (Misc queries) | |||
| text in forumula problem | Excel Programming | |||
![BerkshireGuy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
