Is the IF statement what I need?

M

Mezani

I have two cells that each have drop down lists. The first cell has the text
yes and no, If i choose yes i want the second cell to return N/A for example,
and if it is no I want the drop down list to be usable in the second cell.

Thanks for any help
 
F

FloMM2

Mezani<
Yes, in a word. This is what I came up with:
In cell A1, Data Validation:
Allow: List
Source: Yes, No
In cell B1, Data Validation:
Allow: List
Source: 1,2,3,4
In cell B1, formula: "=IF(A1="Yes", "N/A", 0)"
This will allow you to change the entry in A1; however, it will not allow
you to change the entry in B1. As soon as you select an item in the drop down
list, it overwrites the formula.
hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
MS Project Center-Autolink column fields 0
Drop down list control value in vba 2
Newbie Help - IF Yes No Function 0
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
If function help 4

Top