Posted to microsoft.public.excel.misc

Niek Otten

Posts: n/a

Help! A "logical" question :)

Absolutely right, JE!

Thanks,

Niek

"JE McGimpsey" wrote in message
...
Just a note - the UCASE()'s are unnecessary in this formula since XL's
comparisons are case insensitive.

See my other post for a different answer - the OP's problem statement
seemed rather ambiguous.

In article ,
Bill Martin wrote:

How about:

=if(ucase(left(A1,4))="DEAN","ADK",if(ucase(left(A 1,4))="DAVE","DJM","MWP"))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Finding and deleting question marks	jezzica85	Excel Discussion (Misc queries)	3	February 25th 06 09:05 AM
Summary Page Question	EyeNoNothing via OfficeKB.com	Excel Discussion (Misc queries)	1	February 18th 06 10:03 PM
Pivot table question	gary	Excel Discussion (Misc queries)	1	January 10th 06 06:25 PM
How do I find and replace a question mark in Excel?	Ranpalandil	Excel Discussion (Misc queries)	1	September 7th 05 10:20 PM
Hints And Tips For New Posters In The Excel Newsgroups	Gary Brown	Excel Worksheet Functions	0	April 15th 05 05:47 PM

All times are GMT +1. The time now is 10:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us