Make cells match
 

In sheet 1 I am asking several Yes/No questions. I have a cell after the Yes
and after the NO that I want the value "X" entered into. It will of course
either be one or the other. I then want that "X" to show up in sheet 2, which
is a form I want filled in with the data from sheet 1. If I simply do A1 = C1
and B1 = C2 I get a value of "0" in the cell they didn't put an "X" in. So if
the put an "X" in the Yes cell in sheet 1 then an "X" shows up in the Yes
cell in sheet 2, BUT since they didn't put anything in the No cell in sheet 1
a "0" value shows up in the No cell in sheet 2. Any Help???

=if(sheet1!A1="","",sheet1!A1)
If there is no value in cell a1 on sheet 1, this formula
on sheet 2 will display a blank cell. otherwise it will
display any value in cell a1 on sheet 1.

-----Original Message-----
In sheet 1 I am asking several Yes/No questions. I have a
cell after the Yes
and after the NO that I want the value "X" entered into.
It will of course
either be one or the other. I then want that "X" to show
up in sheet 2, which
is a form I want filled in with the data from sheet 1. If
I simply do A1 = C1
and B1 = C2 I get a value of "0" in the cell they didn't
put an "X" in. So if
the put an "X" in the Yes cell in sheet 1 then an "X"
shows up in the Yes
cell in sheet 2, BUT since they didn't put anything in
the No cell in sheet 1
a "0" value shows up in the No cell in sheet 2. Any
Help???
.