I would like to know if someone could tell me how to do this.

I have to check if a cell contains the letter M. If it does, then the
word monday must be inserted into another cell. If it is not M, then it
must check to see if it is a T for tuesday. This must continue, checking
for w, th, and f.

I have been trying something like this, but it doesnt work:

{for, say L3}

=if(H3=M,monday,(if(H3=T,tuesday,____________)))

I skipped the ___________

Help?


--
brookdale
------------------------------------------------------------------------
brookdale's Profile: http://www.excelforum.com/member.php...o&userid=24617
View this thread: http://www.excelforum.com/showthread...hreadid=382076