Looking for if between statement

[rlkerr]

I have tried several formulas on the forum and help, but I can't get them to work.

I need a formula to read
if b13 is between 0 and 4 then return 10, or if b13 is between 5 and 9 then return 15 or if b13 if between 10 and 19 return 20.

I tried this formula but kept getting an error.
=IF(AND(B13>0,B13<=4),"10",0),IF(AND(B13>=5,B13<=9),"15",0),IF(AND(B13>=10,B13<=19),"20",0)

[contaminated]

Try simple LOOKUP

=LOOKUP(B13,{0,5,10},{10,15,20})

[peterjuhnke]

Hello R
Basisally or formula was correct, except the AND will result in a true or false answer,
=IF(AND(B13>0,B13<=4)=true,"10",0),IF(AND(B13>=5,B13<=9)=true,"15",0),IF(AND(B13>=10,B13<=19)=true,"20",0)
Regards
Peter
You may also need to remove the " "'s.

[rlkerr]

Well, B13 may be any number. So, if it is 0 thru 4 then put 10, or if its 5 thru 9 then put 15. Does this help?

[rlkerr]

Peter that return #value!. I even removed the " "

[ehildmann]

Here's how I usually write those formulas:

=IF(B13<5,10,IF(B13<10,15,IF(B13<20,20,"")))

[rlkerr]

That worked perfect. Thank you so much.