Converting no. to Percentage: Excel formula.

[pedie]

Hi, how can i divide the numbers to percentage to make it to 100%, taking 75% as 100%.


Thanks for helping me advance.

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=18 width=64>75%

​

</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=18>20

​

</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=18>10

​

</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=18>15

​

</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 height=18>30

</TD></TR></TBODY></TABLE>​

I think my real question is to get the valeus of points in 75%.

like 5 is 50% of 10%, taking 10% as 100%
<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=18 width=64>10%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d99795; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=64>100%</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=18>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>50%</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #d99795; HEIGHT: 13.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=18>5</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d99795; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>50%</TD></TR></TBODY></TABLE>


Thanks again.

 

[shg]

If 75% scales to 100%, then divide each number by 75%, e.g.,

=60%/75% = 80%

 

[meldoc]

Hi Pedie

Try.

Excel Workbook
	A	B
1	75%
2	20	26.66667
3	10	13.33333
4	15	20
5	30	40
6		100
Sheet1

Excel 2010

Cell Formulas
Range	Formula
B2	=A2/SUM($A$2:$A$5)*100
B3	=A3/SUM($A$2:$A$5)*100
B4	=A4/SUM($A$2:$A$5)*100
B5	=A5/SUM($A$2:$A$5)*100
B6	=SUM(B2:B5)

Or

Excel Workbook
	A	B
1	75%
2	20	27%
3	10	13%
4	15	20%
5	30	40%
6		100%
Sheet1

Excel 2010

Cell Formulas
Range	Formula
B2	=A2/SUM($A$2:$A$5)
B3	=A3/SUM($A$2:$A$5)
B4	=A4/SUM($A$2:$A$5)
B5	=A5/SUM($A$2:$A$5)
B6	=SUM(B2:B5)

 

[pedie]

hi Brian...Perfect! thanks.. the second table is what i want.
Shg, thanks...that also gives me the correct result...the thing is that the besides 75% they are just numbers...and it is giving me 1000% so i have to re-multiply it with 100..but thanks again for the resolution....


Thanks guys!
Have a great weekend!

Excel Workbook
	A	B
1	75%
2	20	27%
3	10	13%
4	15	20%
5	30	40%
6		100%
???

Excel 2010

Excel Workbook
Cell	Formula
B2	=A2/SUM($A$2:$A$5)
B3	=A3/SUM($A$2:$A$5)
B4	=A4/SUM($A$2:$A$5)
B5	=A5/SUM($A$2:$A$5)
B6	=SUM(B2:B5)
???