Yes.
Try:
If(A2="yes",0,A3)
The text you are testing against must either be in quotations or in a cell,
e.g.
In A4 put, Yes, the the formula becomes
If(A2=A4,0,A3)
--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
"Craig" wrote in message
...
Is it possible to use an if statement when the reference
cell is a Text value.
Cell a2 is 'Yes'
If(A2=yes,0,A3)