View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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