IF Function

[vjohn]

I'm trying to create a ranged condition and my formula doesn't seem to work.

Condition:
[TABLE="width: 157"]
<tbody>[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
0 - 5 days 1
6 - 12 days 2
13 - 20 days 3
> 20 days 4

formula:

if(a1=<5, 1, ""), if(and(a1>=6, a1<=12, 2,""), if(and(a1=>13, a1=<20), 3, ""), if(a1>20, 4,"")

 

[Aladin Akyurek]

Try...

=MATCH(A1,{0,6,13,21},1)

 

[Vikas Kumar]

Try...

=MATCH(A1,{0,6,13,21},1)

Great one.....

Need A few condition over here. Could you please suggest How should I modify this formula to return "A","B","C","D" respectively beside 1,2,3,4.

 

[Aladin Akyurek]

Great one.....

Need A few condition over here. Could you please suggest How should I modify this formula to return "A","B","C","D" respectively beside 1,2,3,4.

This should do that:

=LOOKUP(A1,{0,6,13,21},{"A","B","C","D"})

 

[Vikas Kumar]

This should do that:

=LOOKUP(A1,{0,6,13,21},{"A","B","C","D"})

Yes. This did that. Thanks! ☺.

 

[Aladin Akyurek]

Yes. This did that. Thanks! ☺.

You are welcome.