Hi
Something like:
=IF(A2=6,"Yes",0)

Andy.

"At A Loss" wrote in message
...
When using a IF formula, one answer is false.
Can the word FALSE be changed to a zero?
Would appericate a "simple" example...
Thanks in advance