Hi Bill,

You can see I'm lazier than you a I tried to avoid holding the SHIFT key
:-)

--
Kind regards,

Niek Otten

"Bill Martin" wrote in message
...
On Thu, 2 Mar 2006 08:03:27 -0800, CMIConnie wrote:

I think I am making this more difficult than it is, but I can't sort it
out
in my mind. I need a formula that does the following:
Returns "ADK" if the ref cell contains Dean, dean, Dean's, dean's or
returns
"DJM" if the same ref cell contains Dave, dave, Dave's, dave's, and
returns
"MWP" if there is anything else but Dean or Dave or David in the cell.
I'm
thinking that I can use the logic if it finds an e in the 2nd position,
return "ADK" or if it finds an a in the 2nd position then return "DJM".
Am I
on the right track with this? It seems like there are too many logigals
for
an if/then formula?
Any help would be GREATLY appreciated! (I am using Excel 2000)

-------------------------

How about:

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

Bill