I am looking for a formula that when I choose one choice in a drop down menu it will change automatically change the answer in two additional cells. The first drop down menu has four choices, however 3 of them will give the same answers in the two additional cells.
Hello & Welcome to the Forum,
Not a lot to go on here, but here is an example.
North, South, East, and West in the drop down of cell A1
C1 =IF(OR(A1={"North","South","East"}),"Choice One","")
D1 =IF(A1="West","Choice Two","")
HTH
Regards, Jeff
Jeff,
Thanks Jeff for the quickness. Will this work if the additional 2 cells are drop downs as well?
No, you can't have both a drop down and a formula in the same cell.
Did you see my PM?
Yes... well atleast I think I did. This is the first ever forum I have signed up for. What I am needing is if of the answers in cell one are checked, then cell 2 which is a yes or no question, will equal No. If they equal no, then cell 3 is a question of Good, Bad, None, then cell 3 will equal none. Thanks for your help!!!!!
Can you please return a PM to me answering the question I asked?
As far as your query, can you put together a small sample workbook with a clear before and after?
I'm not entirely clear on what you mean by checked, but this sounds possible.
Would you like this before and after sent to your email?
No you can attach it here...
Attach a sample workbook.
When you are in Advanced reply, click on the paperclip to open the upload window.
View Pic
Thanks for getting my name changed!!
In D2 >> =IF(OR(C2={"Native","RCF","Transfer"}),"NO","")
For E2, I see you have a drop down there, but again as stated earlier you can't have a drop down and a formula at the same time.
So, for E2, what do you want?
Do you need the drop down or would the same formula in D2 work?IF Native, RCF, Or Transfer are selected in C2, then D2 would = "NO" and E2 would = "None"
Also, if at all possible you should stay away from merging cells...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks