Thread: tricky if statement
View Single Post
  #2   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
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?

Reply With QuoteReply With Quote