The following formula is not doing what it is supposed to be doing:

=IF(AND(I87-J870,S87="Yes"),0,I87-J87)

A value should only be returned if S87="Yes"

What happens is a value is returned regardless if S87="Yes" or not. Anyone
know what is wrong here?

Thanks
Pat