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

I think you mean this:

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

or it could be:

=IF(AO1=T1,P1-0.5,P1)

In future postings, please make the cell references more clear.

Hope this helps.

Pete

On Jan 30, 7:03*pm, Tanya Berfield
wrote:
I need an If statement that if AO=T subtract .5 from P otherwise do nothing.
Suggestions?

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

To ensure that you get the answer you need, it would be best to provide sample
data and the result you are expecting. Include the location of the data in your
example.

That did it, thanks for the help!

"Pete_UK" wrote:

I think you mean this:

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

or it could be:

=IF(AO1=T1,P1-0.5,P1)

In future postings, please make the cell references more clear.

Hope this helps.

Pete

On Jan 30, 7:03 pm, Tanya Berfield
wrote:
I need an If statement that if AO=T subtract .5 from P otherwise do nothing.
Suggestions?

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?

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?



A complete cell reference has a column letter and a row number (A1 through
IV65536 until the most recent version). So, in exactly what cells are each of
these pieces of information?

You're welcome.

Pete

On Jan 30, 7:28*pm, Tanya Berfield
wrote:
That did it, thanks for the help!



"Pete_UK" wrote:
I think you mean this:

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

or it could be:

=IF(AO1=T1,P1-0.5,P1)

In future postings, please make the cell references more clear.

Hope this helps.

Pete

On Jan 30, 7:03 pm, 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 -

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 -