Try this.

IF(hours<=20,hours*wages,IF(AND(hours20,hours<=30 ),(hours*wages+(hours-20)*wages*1.5),(hours*wages+(hours-20)*wages*1.5+(hours-30)*2)))

"Denise" wrote:

Would anyone know an if statement for calculating pay rates? The rules a
For the first 20 Hours you get hourly wage * hours
For the next 10 Hours you get hourly wage * (hours*1.5)
For anything abouve 30 hours you get hourly wage * (hours*2)

Thank you,

Denise