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
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