Compare values and conditions

Closed
Report
Posts
1
Registration date
Thursday May 19, 2011
Status
Member
Last seen
May 19, 2011
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
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

1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like