Ah, spoke too soon !!

I think you are using my first suggestion, and you will need to amend
it to this:

=IF(AO1="T",IF(P15,P1-0.5,P1),P1)

Hope this helps.

Pete

On Jan 30, 7:35*pm, Tanya Berfield
wrote:
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?- Hide quoted text -

- Show quoted text -