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

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

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
 
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
 
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.
 
Back
Top