Consulting

Results 1 to 3 of 3

Thread: Formula Modification Help with And/OR

  1. #1

    Formula Modification Help with And/OR

    All, I need a little bit more help on this payroll file using AND/OR conditions (attached).

    Column D should show 'Yes' for an employee that is enrolled in Medical and works < 20 hours in any of the past 4 weeks (not necessarily all 4 weeks). So, on the file attached cell D8 should show 'yes' because he has medical (column A), and in week 34 (col K), he worked less than 20 hours.


    Could someone help me update the formula?

    Thank you.
    Attached Files Attached Files

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    If I'm understanding

    =IF(AND(A8="Medical",OR(J8<20,K8<20,L8<20,M8<20)),"Yes","Nope")

    Capture.JPG
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  3. #3
    Thanks for your help, Paul! Hope you have a wonderful evening.

Posting Permissions

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