Hi again JBeaucaire - you've helped me before...I'm not sure I understand how to provide samples. Do you mean directly in the spreadsheet? Column Q is where I want the formula to reside and is where the current formula is. It meets all of my needs except for the add on which would say that if column m equals C or EW and P is less than Q1 then calculate a new pay rate based on R1.

So should I include a sample of the add on. in the spreadsheet and then tell you which cell the sample answer resides in? Sorry if I'm being dense.