Desplay zero if yes
 

=I29-J29

If the above formula returns a value greater than "0" (zero) and S29
contains the value "Yes" return "0" On the otherhand if S29 contains nothing
return whtaever value =I29-J29 returns.

Is this possible?

Thank you if you know.

Pat

Hi
=IF(AND(I29-J290,S29,"Yes"),0,I29-J29)

--
Regards
Frank Kabel
Frankfurt, Germany

Pat wrote:
=I29-J29

If the above formula returns a value greater than "0" (zero) and S29
contains the value "Yes" return "0" On the otherhand if S29 contains
nothing return whtaever value =I29-J29 returns.

Is this possible?

Thank you if you know.

Pat

one way:

=IF(ISBLANK(S29),I29-J29,IF(AND(I29J29,S29="Yes"),0,"Undefined"))



In article ,
"Pat" wrote:

=I29-J29

If the above formula returns a value greater than "0" (zero) and S29
contains the value "Yes" return "0" On the otherhand if S29 contains nothing
return whtaever value =I29-J29 returns.

Is this possible?

Thank you if you know.

Pat

Should be: =IF(AND(I29-J290,S29="Yes"),0,I29-J29)

Ian P

"Frank Kabel" wrote:

Hi
=IF(AND(I29-J290,S29,"Yes"),0,I29-J29)

--
Regards
Frank Kabel
Frankfurt, Germany

Pat wrote:
=I29-J29

If the above formula returns a value greater than "0" (zero) and S29
contains the value "Yes" return "0" On the otherhand if S29 contains
nothing return whtaever value =I29-J29 returns.

Is this possible?

Thank you if you know.

Pat

Hello Frank,

I am getting a #VALUE! error returned.

Pat


"Frank Kabel" wrote in message
...
Hi
=IF(AND(I29-J290,S29,"Yes"),0,I29-J29)

--
Regards
Frank Kabel
Frankfurt, Germany

Pat wrote:
=I29-J29

If the above formula returns a value greater than "0" (zero) and S29
contains the value "Yes" return "0" On the otherhand if S29 contains
nothing return whtaever value =I29-J29 returns.

Is this possible?

Thank you if you know.

Pat