formula for excel data

[wan_amri]

Hi I'm not sure whether this is the right forum to ask for help with my problem.

I have created a worksheet in Excel. In this sheet, I have many columns. However, I have 2 columns that needs help with creating formula. First column is for inputting dates. Second column is where it should automatically show "N/A" when I enter a date on the first column.

Can anyone who knows the formula to create this help me pleaseeeee???

Thanks.

[ChuckFickens]

Seems a strange thing to want to do without more explaination so I may have got the wrong end of the stick, but....

=IF(A1="","","N/A")

Will enter N/A into the cell with the formula if A1 has anything at all put into it

[chelle7272]

Am i reading this wrong? Wouldn't you just have a column of N/A?

[wan_amri]

Hi Thanks,

Let's say I have columns A and B. In cell A1 I will enter a date. What I would like to happen is when I entere a date in cell A1, cell B1 will be filled with N/A automatically. Vice versa ... when i enter a date in cell B1, cell A1 will be filled with N/A automatically.

So how do i create formula for this?

Thanks.

[ChuckFickens]

I'm not sure you can because you'd be trying to put a value and a formula in each cell.

[dundurn]

You'll also hit the problem that if cell a2, (say), refers to cell b2, and cell b2 refers to a2, then you'll have a circular reference i.e. the value of a cell depends on another cell which is itself dependent on the value of the first cell. It may help to disentangle your problem if you explain how the two date values would be inter-related and therefore why the presence of one would make the other irrelevant and vice versa.