ExcelBanter - Changing 1 word to another word on a different page

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing 1 word to another word on a different page (https://www.excelbanter.com/excel-discussion-misc-queries/255592-changing-1-word-another-word-different-page.html)

Circuitman57

Changing 1 word to another word on a different page

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

Russell Dawson

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

Russell Dawson

Changing 1 word to another word on a different page

Missed a bit
=IF(Sheet2!A1="yes","no",IF(Sheet2!A1="no","yes"," "))
--
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

Circuitman57

Changing 1 word to another word on a different page

Thanks Russell

"Russell Dawson" wrote:

Missed a bit
=IF(Sheet2!A1="yes","no",IF(Sheet2!A1="no","yes"," "))
--
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

All times are GMT +1. The time now is 07:39 AM.