IF function with combination of conditions

[Weco Controller]

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.

 

[etaf]

does the employee only appear once in column A with the Total in B

=IF( B2<=500, 1, If( B2<1000,501,1000))

 

[Weco Controller]

Yes, the employee appears only once in column A with total in B.
This formula worked!! Thank you soooooo much!!!

 

[etaf]

you are welcome