I thought that did it but not quite. In P i have total hours worked, if AO
shows T (true) and P is more than 5 i need to deduct .5 - am i missing any
info?

"Tanya Berfield" wrote:

I need an If statement that if AO=T subtract .5 from P otherwise do nothing.
Suggestions?