Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to change a "No" to a "Yes" i
I have a work sheet that if on page 2 the cell says No, then on page 1 it
says Yes and if on page 2 the cell is Yes then on page 1 it is No? What formula do I use, and how do I cereat it without getting a circle error? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to change a "No" to a "Yes" i
You need to define, "the cell". Which / Worksheet / cell(s), specifically?
You also need to define, "it". Which Worksheets / cell(s), specifically, do you mean by this? "Circuitman57" wrote: I have a work sheet that if on page 2 the cell says No, then on page 1 it says Yes and if on page 2 the cell is Yes then on page 1 it is No? What formula do I use, and how do I cereat it without getting a circle error? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to change a "No" to a "Yes" i
Excel doesn't push data to other cells very well. But it can retrieve data
(using formulas) very easily. I'd use one cell for input and put a formula in the other cell. Then only update that first cell. Circuitman57 wrote: I have a work sheet that if on page 2 the cell says No, then on page 1 it says Yes and if on page 2 the cell is Yes then on page 1 it is No? What formula do I use, and how do I cereat it without getting a circle error? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to change a "No" to a "Yes" i
See your other posting
-- Russell Dawson Excel student "Circuitman57" wrote: I have a work sheet that if on page 2 the cell says No, then on page 1 it says Yes and if on page 2 the cell is Yes then on page 1 it is No? What formula do I use, and how do I cereat it without getting a circle error? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
=IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) |