tricky if statement

[Tanya Berfield]

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

 

[Pete_UK]

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

 

[Glenn]

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.

 

[Tanya Berfield]

That did it, thanks for the help!

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

 

[Tanya Berfield]

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?

 

[Glenn]

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?

 

[Pete_UK]

You're welcome.

Pete

That did it, thanks for the help!






- Show quoted text -

 

[Pete_UK]

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(P1>5,P1-0.5,P1),P1)

Hope this helps.

Pete