If you want to change the contents of a cell based on what is currently in
that same cell, you will need VBA programming. Post back if this is what
you want. HTH Otto
"Trikester824" wrote in message
...
That returns different values for a cell that contains a yes, no or N/A.