lower gets highest percentage

[faizee]

i have numeric data in first column of table
i want to give the percentage of each value, but lower should get 100%,
then higher values get lower percentage comparetively

pls help

 

[Robert Mika]

i have numeric data in first column of table
i want to give the percentage of each value, but lower should get 100%,
then higher values get lower percentage comparetively

pls help

does this help?

Excel Workbook
	A	B
1	1	97%
2	2	94%
3	3	92%
4	4	89%
5	5	86%
6	6	83%
7	7	81%
8	8	78%
Sheet1

 

[faizee]

	A</SPAN>	B</SPAN>
1</SPAN>	1.1</SPAN>
2</SPAN>	1.22</SPAN>
3</SPAN>	0.9</SPAN>
4</SPAN>	0</SPAN>	100%</SPAN>		100% because it is min</SPAN>
5</SPAN>	1.1</SPAN>
6</SPAN>	12</SPAN>
7</SPAN>	13</SPAN>	0%</SPAN>		0% because it is max</SPAN>
8</SPAN>	9.11</SPAN>
all the other values will be between 0 - 100%, </SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=3><COL><COL span=2></COLGROUP>

 

[Robert Mika]

	A	B
1	1.1
2	1.22
3	0.9
4	0	100%		100% because it is min
5	1.1
6	12
7	13	0%		0% because it is max
8	9.11
all the other values will be between 0 - 100%,

So you need only for minimum and maximum or for all values?
If the first option:

Excel Workbook
	A	B
1	1.1
2	1.22
3	0.9
4	0	100%
5	1.1
6	12
7	13	0%
8	9.11
Sheet1

 

[Peter_SSs]

Is this what you mean? If not please post the expected results for your sample data with further explanation about how they are calculated.
Formula copied down

Excel Workbook
	A	B
1	1.1	92%
2	1.22	91%
3	0.9	93%
4	0	100%
5	1.1	92%
6	12	8%
7	13	0%
8	9.11	30%
Percentage

 

[faizee]

Thanks
Yes, This is what I want...

 

[Peter_SSs]

Sorry, that formula I posted was in fact incorrect. It was a fluke that it produced the correct answers - because the lowest value happened to be 0. You can test that by changing the lowest value from 0 to say 0.3
The formula should be

=(MAX(A$1:A$8)-A1)/(MAX(A$1:A$8)-MIN(A$1:A$8))

 

[faizee]

thank you peter,!