Thread: tricky if statement
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default tricky if statement
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 -

Reply With QuoteReply With Quote