 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008what 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 In E10 enter: =F9/E9 then format E10 as percentage  SignatureGary''s Student - gsnu200772 > 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 > 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 oops. missed the f part. maybe i need to upgrade my glasses. > hi > e9 cannot contain both 35 and 1 so... [quoted text clipped - 11 lines] > > 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 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.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.