Can I put "OR" in a IF(AND statement?

[grilla79]

Hi. I’m using this expression on a worksheet.

=IF(AND(A13="p",C13="small",E8<11),"1 km","n/a")

There are 7 different possible entries I need to put in C13 but I can’
figure out how to express it – consequently I had to group them into th
two categories “small” and “large”.

What I’d like to be able to do is to modify this so I can put th
“raw”data in – so I can say something like IF(AND(A13=”p”, c13 = “a” o
“b” or “c” or “d”, E8 <11), “1 km”, “n/a”.

Of course the next thing I need to do is for the other possible entrie
– IF(AND(A13=”p”, C13=”e” or “f” or “g”, E8< 11, “10 km”, “n/a”.

Seems like it would be sort of “OR” statement but I’ve tried ever
combination I can think of and nothing works.

Using the “raw” data a-g in the C13 box will be handy for another par
of the spread sheet I’m working on.

I’m also trying to figure out if I can do a drop-down box or scroll t
speed up input of the text I have abbreviated as a-g. Is it possibl
to insert a dropdown into excel?

Thanks

Do

 

[Bob Phillips]

=IF(AND(A13="p",E8<11),IF(OR(C13={"a","b","c","d"}),"1
km",IF(OR(C13={"e","f","g"}),"10 kim"," n/a")),"n/a")

See http://www.contextures.com/xlDataVal01.html