if function in an excel cell

[Helpmeplease1]

I'd like to know how to put this condition in a cell

IF 100<A1<200 THEN
1
ELSEIF 200<A1<300 THEN
2
ELSE any other value of U10
0


Thanks for any help!

[Special-K]

"What does else any other value of U10" mean?

Try

=IF(AND(A1>100,A1<200),AND(A1>200,A1<300),2,U10))

[Sam Capricci]

you could try this... =LOOKUP(A1,{0,100,200,300},{0,1,2,0})

[Helpmeplease1]

"What does else any other value of U10" mean?

Try

=IF(AND(A1>100,A1<200),AND(A1>200,A1<300),2,U10))

sorry, i meant

IF 100<A1<200 THEN
1
ELSEIF 200<A1<300 THEN
2
ELSE any other value of A1
0

[MrShorty]

For three outputs, the IF function works well. An alternative approach, especially if this is going to expand to multiple possible outputs is to use a lookup table and one of Excel's lookup functions (VLOOKUP() is probably the first one people learn: https://support.office.com/en-us/art...8-93a18ad188a1 ) Pay particular attention to how Excel performs the lookup when the 4th argument is TRUE to understand how this will handle you "between" conditions.

[Helpmeplease1]

you could try this... =LOOKUP(A1,{0,100,200,300},{0,1,2,0})

I tried what you did but instead of 100,200... I wanted to use multiples of a value in cell E20. I don't know what's wrong

LOOKUP(U10,{0,$E$20,2*($E$20),3*($E$20),4*($E$20),5*($E$20),6*($E$20)},{0,1,2,3,4,5,0})