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?

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?

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

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?