+ Reply to Thread
Results 1 to 2 of 2

Picking up letters and reporting something different

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    85

    Picking up letters and reporting something different

    Hi I wonder if anyone can help. In column B I have several different letters (y, l, s) I wan to do is in the cell next the letter put a word, for example when there is a y in the cell, I want the cell next to it to say present. How can I do this?

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

    Re: Picking up letters and reporting something different

    Try... just change what you want it to say for L & S

    =IF(A1="Y","Present",IF(A1="L","Test",IF(A1="S","Test II","")))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1