Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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??? |
#2
|
|||
|
|||
=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??? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Averaging only cells with data | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |