Hi Denise
Oops !! Ithink I told you A1 and A2 for the input data, when it should have
been B1 and B2
Sorry for the confusion.
Michael

"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