tricky if statement

  • Thread starter Thread starter Tanya Berfield
  • Start date Start date
T

Tanya Berfield

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
 
Tanya said:
I need an If statement that if AO=T subtract .5 from P otherwise do nothing.
Suggestions?
Click to expand...

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 said:
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
Click to expand...
 
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 said:
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?
Click to expand...


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?
 
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
 
Back
Top