Excel really is my weak spot and I need help with creating a formula. If anybody would feel helpful, I'd really appreciate it!

Well, the excel-problem I have:

In cell A1 I've entered number 12134. In cell B1 I've added the formula =LEFT(A1;2) (I must add that my formulas are in swedish, but I'll try to translate it as correct as possible).

So, the number I now see in B1 is 12. Then in cell C1 I have the formula =IF(B1>10;1019). And since the value is BIGGER than 10, in C1 I see the number 1019.

The problem is that I want to add, that if the number in B1 also is SMALLER than 19, the TRUE is also 1019.

And to make it even messier, I'd like to add more conditions/terms. Like, if the number is BIGGER than 19 or SMALLER than 21 the TRUE is 2021.

Anyone?

Thanks in advance,

Legedien