Hi Craig, you can use IIF or IF as follows.

'-- code -------------------------------
Answer = IIf([A2].Value = "yes", 0, [A3].Value)
MsgBox Answer
'---------------------------------------

'-- code -------------------------------
If [A2].Value = "yes" Then
Answer = 0
Else
Answer = [A3].Value
End If
MsgBox Answer
'---------------------------------------


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm


/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/


"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)