IF Statement in dropdown list without defaulting to 0?

[Data2link]

Hi, I haven't quit found the answer I'm looking for, so hope I can get some help here

I have a dropdown list that contains the following choices:

Column C (Dropdown list)
Yes,
No,
Partially,
N/A

Column D Has a IF statement that tells the person filling out the form if they must answer that question or not. If not it says NA in this column.

I have an IF statement in Column C with the dropdown list that says: =IF(D9="NA","N/A",)
This works, but then it puts the default in the cell to "0" - I just need it to be blank or default to the If statement of "N/A"

Any ideas?

Thanks

Marcy

 

[Fluff]

How about

=IF(D9="NA","N/A","")

Although the formula will be lost as soon as a value is chosen from the drop down

 

[Data2link]

How about

=IF(D9="NA","N/A","")

Although the formula will be lost as soon as a value is chosen from the drop down

That worked- so simple and I didn't even think of it :D Thanks so much!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Data2link]

OK- so one more thing, when I do that formula,

You're welcome & thanks for the feedback.

You bet. I have one more question- when I do the NA- it puts a score error message because its dividing by 0 in another column- Is there a way to either hide that or make it put a number on there?

 

[Fluff]

I have no idea, as you haven't said what the formula is, but as it's a totally different question, it needs a new thread. Thanks

 

[Data2link]

I have no idea, as you haven't said what the formula is, but as it's a totally different question, it needs a new thread. Thanks

Oh OK sorry- I will report with the formula in a new thread

 

[Data2link]

OK- so one more thing, when I do that formula,

You bet. I have one more question- when I do the NA- it puts a score error message because its dividing by 0 in another column- Is there a way to either hide that or make it put a number on there?

Hi, I'm having an issue wit the code still. The code gets deleted out if you choose a different answer in the dropdown list. So in the beginning, it is blank, or NA, but if you choose any of the other answers (Yes, No, Partially) then it takes the code out. Do I need to lock the cell for it to stick?

Thanks

 

[Fluff]

I know it does that, which is why I said

Although the formula will be lost as soon as a value is chosen from the drop down

Locking the cell will make no difference.

 

[Joe4]

Hi, I'm having an issue wit the code still. The code gets deleted out if you choose a different answer in the dropdown list. So in the beginning, it is blank, or NA, but if you choose any of the other answers (Yes, No, Partially) then it takes the code out. Do I need to lock the cell for it to stick?

A cell can either contain a formula or a hard-coded value, but never both at the same time, and it has no memory of what was in it before.

If you want to do something that can handle both, that would require VBA code.