+ Reply to Thread
Results 1 to 4 of 4

IF OR Help

  1. #1
    Registered User
    Join Date
    12-05-2017
    Location
    Columbus
    MS-Off Ver
    2013
    Posts
    13

    IF OR Help

    I have the first part of this question solved (I think).
    =IF(OR([@[Pay Grade]]="D"), "No","")

    The second part dealing with "Job Status" is were I am having trouble.


    In the Eligible for Bonus column, enter a formula with IF and OR functions to display the text No if the employee's pay grade is D or the employee's job status is a part time (PT). Leave the cell blank if the employee is eligible for a bonus.
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: IF OR Help

    Hello and welcome to the forum.

    You are close! You only have to include the second condition in the OR function. That is:

    =IF(OR([@[Pay Grade]]="D",[@[Job Status]]="PT"),"No","")

  3. #3
    Registered User
    Join Date
    12-05-2017
    Location
    Columbus
    MS-Off Ver
    2013
    Posts
    13

    Re: IF OR Help

    That was it!
    Thanks!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: IF OR Help

    You're welcome. Thanks for the rep!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Last edited by 63falcondude; 12-05-2017 at 04:20 PM. Reason: Rep Added

+ 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