percentage

[Gonzalez]

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

 

[teylyn]

Hi Gonzalez,

that depends on what percentage you want to calculate, i.e.

What is the percentage of J166 to E166, then =J166/E166 = 87.4%

What is the percentage of E166 to J166, then =E166/J166 = 114.4%

cheers, teylyn


I am trying to figure out the total percentage of 2 cell for exampl
E166 HAS

 

[Jacob Skaria]

=J156/E156
and format the formula cell to percentage

 

[FSt1]

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