Posted to microsoft.public.excel.programming

BerkshireGuy[_2_] BerkshireGuy[_2_] is offline

external usenet poster

Posts: 21

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")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why does forumula show in cell instead of formula result?	Ashley	Excel Worksheet Functions	2	May 17th 10 09:45 PM
Autofill cell reference forumula not working	James D	Excel Worksheet Functions	4	August 28th 09 05:11 PM
Retreive part of the value from each cell - Macor and/or forumula	[email protected]	Excel Discussion (Misc queries)	5	October 28th 08 05:32 PM
Is there a forumula that uses colors instead of cell #'s?	JohnAO	Excel Discussion (Misc queries)	5	January 7th 06 03:35 PM
text in forumula problem	scrabtree23[_3_]	Excel Programming	2	July 20th 05 10:24 PM

All times are GMT +1. The time now is 05:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us