Thread: Changing 1 word to another word on a different page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Russell Dawson Russell Dawson is offline
external usenet poster
  
Posts: 52
Default Changing 1 word to another word on a different page
In a1 in sheet1 put
=IF(Sheet2!A1="yes","no","")
--
Russell Dawson
Excel student


"Circuitman57" wrote:

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
Reply With QuoteReply With Quote