Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: If Function

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to help the receptionist with the parking log and validations. 2 stamps are used. If its after 10:30 and they stay more than 2 hours then "Use a 1 day stamp". Any other time use 20 minute stamps.

    This is the function
    a1 10:30 time in
    a2 1:30 time out
    a3 2:30 elasped time

    =IF(a1>0.43681&a3>0.0831,"USE ALL DAY STAMP",IF(ROUND(a3*72,0)>4,4,ROUND(a3*72,0)))

    Heres the problem
    IF(a1>0.43681&a3>0.0831,
    If(a1>10:30am & 3 > 2:00,

    How do I join these 2 conditions or does anyone have a better idea. Thanks

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try;
    =IF(AND(A1>0.437,A3>0.10417),"USE ALL DAY STAMP","USE 20 MINUTE STAMP")

    Ivan

    [ This Message was edited by: Ivan F Moala on 2002-03-22 10:29 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,424
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    With criteria in C1 (10:30:00 AM)
    and D1 (2:00:00 )

    =IF(AND(B2>$C$1,B2-A2>$D$1),"Use a 1 day Stamp","20 Minute Stamp")

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the help, the ladies will really appreciate this.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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