Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    criteria (97/2000)

    Hi All
    lets say that in B1=last name,C1=first name,and D1=checked in. If smith joe checked in would it be possible for excel to put something in A1, like the word here or paid or have a check mark or something.
    Thanks for any help.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: criteria (97/2000)

    Based on what you asked, this would do it (though I am not sure if this is what you want). Put this in A1:

    <pre>=if(and(b1="smith",C1="joe",d1="checked in"),"PAID","")</pre>



    If you only want to mark "checked in" you could just use this in A1:
    <pre>=if(d1="checked in"),"PAID","")</pre>


    If you are looking for something else, you will ahve to be more specific.

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: criteria (97/2000)

    The answer is yes, but how depends on what is in the "checked in" column. If an empty cell means that the person is not checked in, and any entry means that they are checked in, then put the formula below in cell A1 and copy it down the column as far as necessary:

    <pre>=IF(D1<>"","Paid","")
    </pre>

    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: criteria (97/2000)

    Thank you so much for the help. You guys came through again your the greatest. All the girls at work will be very happy.

Posting Permissions

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