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.
Bookmarks