|
|
|
|
| Author |
|
|
Puny Bird
Join Date: Nov 2002
Location: Port Hope (near Toronto) On, Canada
Posts: 4,566
|
Any Excel, Open Office Calc Geeks? Need percentage formula
Any Excel, Open Office Calc Geeks? Need a cell percentage formula please.
He scored 5 goals for every 28 shots on net. What is his percentage of goals per shot on net? rounded to one decimal place I know how to cross multiply it on paper but I need to know how to enter it into a cell. Below gets me everything but the percent. =ROUND(H10/B10;1) which is "28/5 rounded to one decimal place" but I still need the percent. 
__________________
'74 Porsche 914, 3.0/6 '72 Porsche 914, 1.7, wife's summer DD '67 Bug, 2600cc T4,'67 Bus, 2.0 T1 Not putting miles on your car is like not having sex with your girlfriend, so she'll be more desirable to her next boyfriend. |
||
04-11-2016, 10:40 AM
|
|
|
Registered
Join Date: Mar 2003
Posts: 10,322
|
Should be 5/28
Then multiply by 100 =(round(B10/H10;1)*100) |
||
|
04-11-2016, 10:42 AM
|
|
|
Registered
|
just divide 5/28.
and the answer cell, click the % button. you can adjust decimal places with that other buttom with the left/right blue arrow thing. i suck at accel..but i can dazzle with BS perfectly fine.
__________________
poof! gone |
||
|
04-11-2016, 10:50 AM
|
|
|
Registered
Join Date: Dec 2003
Location: Upper Peninsula, Michigan
Posts: 812
|
Mark,
More than one way to do it. Either place =Round(H10/B10,1) into a cell and format it to a percentage or do this: =ROUND((H10/B10)*100,1)&"%"
__________________
Daryl G. 1981 911 SC - sold 06/29/12 |
||
|
04-11-2016, 10:53 AM
|
|
|
Puny Bird
Join Date: Nov 2002
Location: Port Hope (near Toronto) On, Canada
Posts: 4,566
|
Yes, wrong way around was part of the finger trouble.... Thanks
 =ROUND((100*C5/H5);1)
__________________
'74 Porsche 914, 3.0/6 '72 Porsche 914, 1.7, wife's summer DD '67 Bug, 2600cc T4,'67 Bus, 2.0 T1 Not putting miles on your car is like not having sex with your girlfriend, so she'll be more desirable to her next boyfriend. Last edited by Mark Henry; 04-11-2016 at 12:01 PM.. |
||
|
04-11-2016, 11:41 AM
|
|
