| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | Excel Discussion (Misc queries) | |||
| PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | New Users to Excel | |||
| Changing word case in Excel doc | Excel Discussion (Misc queries) | |||
| changing values in a Word Table | New Users to Excel | |||
| Changing the Color of a Word in Formula | Excel Worksheet Functions | |||
Linear Mode
