Changing 1 word to another word on a different page

Circuitman57 · Feb 7, 2010

I have a work sheet that if an answer in a cell on page 2 is "Yes" or "No",
I need it to display the opposite in a cell on page 1

Circuitman57 · Feb 8, 2010

Thanks Russell

Russell Dawson said:
Missed a bit
=IF(Sheet2!A1="yes","no",IF(Sheet2!A1="no","yes",""))