Compare values and conditions

Closed
sal.fresco Posts 1 Registration date Thursday May 19, 2011 Status Member Last seen May 19, 2011 - May 19, 2011 at 10:15 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 24, 2011 at 03:47 AM
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

RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 24, 2011 at 03:47 AM
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
0