Multiple =IF(AND

[RaRaAv1s]

Hi All.

Firstly I'm pretty much a total newbie with Excel, so the answers are probably out there, but I end up getting more confused, because I need to adjust the examples I find to suit me, and I end up messing it up somehow.

I currently have the following (which works):-
=IF(AND(A2>=0,A2<=10), A2+0.5,)

So currently A2 has a value of 5, so it adds 0.5 as needed, to give me my 5.5.
What I need it to do is say A2 had a value of between 11 and 20, it would add 1.5 rather than the 0.5 it adds for any number between 0 and 10. But I still need it to check A2 isn't between 0 and 10, and add that 0.5 if it was.

Many Thanks.

PS I haven't used my exact numbers because it's still a WiP, however it would be very very close to what I need it to do.

[Jonmo1]

Sounds like a job for a lookup..

=LOOKUP(A2,{0,11,21},{0.5,1.5,2.5})

[RaRaAv1s]

Ok thanks it helps, how do I add on the value of A2?

Currently A2 value of 5 gives an answer of 0.5, where as it needs to be added onto the value of A2, so it would be 5.5.

Or do I just have to run a simple "add" formula in another cell?

[Jonmo1]

Ok, that would be

=A2+LOOKUP(A2,{0,11,21},{0.5,1.5,2.5})

[RaRaAv1s]

Awesome, thank you.

[Jonmo1]

You're welcome.