tricky if statement
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?
|