View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default 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