what is the formula for the percentage of 2 cells Safety Stats
 

I am having difficulty with figuring the percentages of 2 cells for safet
stats. Its been a long time since college, anyway if E9 is 35 and F9 is 1 how
do I get the % of the 2 cells to enter in E10

what is the formula for the percentage of 2 cells Safety Stats
 

In E10 enter:
=F9/E9
then format E10 as percentage
--
Gary''s Student - gsnu200772


"Terry" wrote:

I am having difficulty with figuring the percentages of 2 cells for safet
stats. Its been a long time since college, anyway if E9 is 35 and F9 is 1 how
do I get the % of the 2 cells to enter in E10

what is the formula for the percentage of 2 cells Safety Stats
 

hi
e9 cannot contain both 35 and 1 so...
maybe with 35 in e8 and 1 in e9 then
=E9/E8
equals .0286 format as percent = 2.86%
and since you didn't say which is to be a percent of the other...
=E8/E9
equals 35 or format as percent 3500.00%

Regards
FSt1

"Terry" wrote:

I am having difficulty with figuring the percentages of 2 cells for safet
stats. Its been a long time since college, anyway if E9 is 35 and F9 is 1 how
do I get the % of the 2 cells to enter in E10

what is the formula for the percentage of 2 cells Safety Stats
 

Hi Terry,
Format E10 to display %, selecting as many decimal points as you
require.
Then in cell E10 write:
=F9/E9

Try this, but it may not be quite that simple, depending on what the
35 and the 1 actually represent. If this doesn't work, supply a bit
more detail about your data.
Dave.

what is the formula for the percentage of 2 cells Safety Stats
 

oops. missed the f part. maybe i need to upgrade my glasses.



"FSt1" wrote:

hi
e9 cannot contain both 35 and 1 so...
maybe with 35 in e8 and 1 in e9 then
=E9/E8
equals .0286 format as percent = 2.86%
and since you didn't say which is to be a percent of the other...
=E8/E9
equals 35 or format as percent 3500.00%

Regards
FSt1

"Terry" wrote:

I am having difficulty with figuring the percentages of 2 cells for safet
stats. Its been a long time since college, anyway if E9 is 35 and F9 is 1 how
do I get the % of the 2 cells to enter in E10