Weco Controller
New Member
- Joined
- Jun 11, 2014
- Messages
- 10
I have a list with employee names in column A and total hours worked in column B
I'm trying to figure out a formula in column C to give me the following:
a)If the employee is credited with at least 1,000 hours or more for the plan year,enter 1,000
b)If the employee is credited with less than 1,000 hours but more than 500 hours for this plan year, enter 501
c)If the employee is credited with 500 hours or less for this plan year, enter 1.
I'm trying to figure out a formula in column C to give me the following:
a)If the employee is credited with at least 1,000 hours or more for the plan year,enter 1,000
b)If the employee is credited with less than 1,000 hours but more than 500 hours for this plan year, enter 501
c)If the employee is credited with 500 hours or less for this plan year, enter 1.