Hello</SPAN></SPAN>
I need your help! I have Excel 2010.</SPAN></SPAN>
I wish to group my values into intervals than I want to add a mark which later discribe the position of the value.</SPAN></SPAN>
I have two values in %. The 1st is from the Low Yld and the 2nd from the top yield environment. Both are discribe the % of the average of cheks.</SPAN></SPAN>
I have the % calculations but now I want to supplement my database with a new column which collects the marks. For this I need a formula which are selecting the right intervals than pull a mark from the reference table. The intervals border are in the table below and in the picture. </SPAN></SPAN>
<TBODY>
</TBODY>
http://kepfeltoltes.hu/140505/diagram_www.kepfeltoltes.hu_.png
Thanks in advance</SPAN></SPAN>
lollek</SPAN></SPAN>
I need your help! I have Excel 2010.</SPAN></SPAN>
I wish to group my values into intervals than I want to add a mark which later discribe the position of the value.</SPAN></SPAN>
I have two values in %. The 1st is from the Low Yld and the 2nd from the top yield environment. Both are discribe the % of the average of cheks.</SPAN></SPAN>
I have the % calculations but now I want to supplement my database with a new column which collects the marks. For this I need a formula which are selecting the right intervals than pull a mark from the reference table. The intervals border are in the table below and in the picture. </SPAN></SPAN>
Sample:</SPAN> | Entry</SPAN> | Low YLd </SPAN> | Top Yld</SPAN> | Mark</SPAN> | Reference table:</SPAN> | x axis Low YLd </SPAN></SPAN> | y axis Top Yld</SPAN> | Mark</SPAN></SPAN> | ||
A</SPAN> | 120.3</SPAN> | 102.9</SPAN> | A(**)</SPAN> | 104<</SPAN></SPAN> | 104<</SPAN></SPAN> | A(***)</SPAN></SPAN> | ||||
B</SPAN> | 119.7</SPAN> | 101.8</SPAN> | A(*)</SPAN> | 102-104</SPAN></SPAN> | 102-104</SPAN></SPAN> | A(**)</SPAN></SPAN> | ||||
C</SPAN> | 108.4</SPAN> | 103.6</SPAN> | A(**)</SPAN> | 99-102</SPAN></SPAN> | 99-102</SPAN></SPAN> | A(*)</SPAN></SPAN> | ||||
D</SPAN> | 110.1</SPAN> | 103.1</SPAN> | A(**)</SPAN> | 90-99</SPAN></SPAN> | 106<</SPAN></SPAN> | I(***)</SPAN></SPAN> | ||||
E</SPAN> | 99.5</SPAN> | 105.1</SPAN> | A(*)</SPAN> | 85-90</SPAN></SPAN> | 104.5-106</SPAN></SPAN> | I(**)</SPAN></SPAN> | ||||
F</SPAN> | 89.8</SPAN> | 106.9</SPAN> | I(***)</SPAN> | 80-85</SPAN></SPAN> | 103-104.5</SPAN></SPAN> | I(*)</SPAN></SPAN> | ||||
G</SPAN> | 87.0</SPAN> | 95.0</SPAN> | XXXX</SPAN> | 114<</SPAN></SPAN> | 97.7-99</SPAN></SPAN> | R(***)</SPAN></SPAN> | ||||
....</SPAN> | 93.7</SPAN> | 105.0</SPAN> | ....</SPAN> | 109-114</SPAN></SPAN> | 96.5-97.7</SPAN></SPAN> | R(**)</SPAN></SPAN> | ||||
95.2</SPAN> | 104.5</SPAN> | 106-109</SPAN></SPAN> | 95.5-96.5</SPAN></SPAN> | R(*)</SPAN></SPAN> | ||||||
119.6</SPAN> | 99.2</SPAN> | not in any interval</SPAN></SPAN> | not in any interval</SPAN></SPAN> | XXXX</SPAN></SPAN> | ||||||
111.6</SPAN> | 100.7</SPAN> | |||||||||
... | ... |
<TBODY>
</TBODY>
http://kepfeltoltes.hu/140505/diagram_www.kepfeltoltes.hu_.png
Thanks in advance</SPAN></SPAN>
lollek</SPAN></SPAN>