Drop down lists

G

Guest

Hi,
I have created a drop down lists with following formula (linked to multiple
named rows) so if say cell D17 was 20 then it would return a range of numbers
to select in drop down relating to a certain list (twenty.one).
=IF(D17="20",twenty.one,IF(D17="22",twentytwo.one,IF(D17="30",thirty.one,IF(D17="40",forty.one))))
This works but I need to add an AND in to the formula and when I try I just
get an error. Is it possible to put in an AND in validation?
Many thanks.
 
G

Guest

I wanted it to look at a second cell as a reference but this is too many
arguments so I am going to try and work another way around it.
Thanks.
 
S

shail

Hi Carrie,

You need to put the AND formula in this way -

=IF(AND(A1=17,A2=0),mm,cc)

This is just an example. Put the formula into the validation dropdown
list.

Hope that Helps,

Thanks
Shail
 

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

Formula Based on Multiple Sheets 5
Calculating Cell Occupation 2
can I create a formula using text made from the concentate comman. 4
Validation based on values 1
expanding custom formatting without removing existing cell formatting? 3
help with multiple function from drop down box 6
Using IF with SEARCH 3
Data entered from list automatically enters number in another cell 4

Top