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
|