multiple query

Hello and thanks in advance for any help.

I need to do the following:

three ranges in age:
<45
between 46 and 55
>56

six ranges in "pieces":
75000
75000 to 150000
150001 to 250000
250001 to 350000
350001 to 450000
450001 to 550000
> 550000

and 11 ranges in "Result"
QM
1
2
3
4
5
6
7
8
9
10

for example:

if "age" is <45 and "values" = 75000 the "result" should be "QM"

but if "age" is ">56" and "value" is 75000 result should be "1"


can anyone help?

regards
Sal