percentages

[stebrownsword]

Hiya,

My first week back from holiday and forgot everything on excel

my question is how do i find a % of total

example
Column A Column B Column C
<TABLE style="WIDTH: 348pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=465 border=0><COLGROUP><COL style="WIDTH: 116pt; mso-width-source: userset; mso-width-alt: 5668" span=3 width=155><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 116pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=155 height=20>

12 weeks+​

</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 116pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=155>

10-12 Weeks​

</TD><TD class=xl66 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 116pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" width=155>

>10 Weeks​

</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>

Row 1 5​

</TD><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">

2​

</TD><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent">

3​

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

desired result 50% 20% 30%


Thanks everyone

 

[Misca]

Try:
=A1/SUM(A1:C1)

or to get the cell formatting at the same time:
=TEXT(A1/SUM(A1:C1),"0 %")

 

[stebrownsword]

thank you