formual for wages with a raise and different hours for time periods

[THoxsey]

An employee is getting a raise in May (5) and will have different hours for the summer and school year. Below is how I have the data set up but I cannot figure out the “If, Then” statement.

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Month Of Raise 5 1 2 3 4 5 6 7 8 9 10 11 12
Monthly Wage Amt Should be 591 591 591 591 867 3,467 3,467 3,467 867 867 867 867
# Hours No Raise Raise
Summer Hours 40 2,363 3,467 Period>=6,Period<=8
School Hours 10 591 867 Period<=5,Period>=9

[63falcondude]

In G5, try

=IF(OR(G4={6,7,8}),IF(G4<$B4,$C7,$D7),IF(G4<$B4,$C8,$D8))

[THoxsey]

Thank you very much!!! It worked.....

[63falcondude]

You're welcome, happy to help!