ExcelBanter - percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - percentage (https://www.excelbanter.com/excel-discussion-misc-queries/258272-percentage.html)

Gonzalez

percentage

I am trying to figure out the total percentage of 2 cell for example E166 HAS
159
AND J166 HAS 139 HOW WOULD I GET THE PERCENTAGE OR HOW DO YOU WRITE IT--
Sgt.Gonzalez

Jacob Skaria

percentage

=J156/E156
and format the formula cell to percentage

--
Jacob

"Gonzalez" wrote:

I am trying to figure out the total percentage of 2 cell for example E166 HAS
159
AND J166 HAS 139 HOW WOULD I GET THE PERCENTAGE OR HOW DO YOU WRITE IT--
Sgt.Gonzalez

FSt1

percentage

hi
not sure exactly what you mean. i am assuming that you mean as a per cent of
the total of the 2.
for E166....=E166/(E166+J166)
for J166....=J166/(E166+J166)

regards
FSt1

"Gonzalez" wrote:

I am trying to figure out the total percentage of 2 cell for example E166 HAS
159
AND J166 HAS 139 HOW WOULD I GET THE PERCENTAGE OR HOW DO YOU WRITE IT--
Sgt.Gonzalez

All times are GMT +1. The time now is 09:22 PM.