Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Class detector (97)

    I'm working on detecting student in which class they should be...
    i've got the student name is cell A2 while the class which the student should be
    is in cell B2

    If there is number or text entered in cell A2
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Class detector (97)

    Before I forget..I'm hoping something like formula to solved this thing ..
    thanks

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Class detector (97)

    Try putting
    <pre>=IF(ISBLANK(A2),""," 2 EXCELLENT ")</pre>

    in B2 and see if that gives you what you want

    Andrew C

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Class detector (97)

    Thanks Andrew..you are excellent

Posting Permissions

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