Help to fix formula ="Yes"
 

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

Hi,
the "yes" in the formula needs to be double quoted...
the yes in cell s87 does not.

peter
-----Original Message-----

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


.

Peter,
What through the formula is that the cell had been custom formatted. I have
now changed the formula to:
=IF(AND(I87-J870,S87=1),0,I87-J87)
Thanks



"peter" wrote in message
...
Hi,
the "yes" in the formula needs to be double quoted...
the yes in cell s87 does not.

peter
-----Original Message-----

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


.