A formulae contained by Excell to work out %?
Question: I run a pool team, i requirement a formulae to work out win % against number of games played! ie if they have played 14 ganes and won 9 of them what is that as %? Thanks
Answers:
=IF((games won cell),games won cell/games played cell,0)
later right click on cell and select format cell.
goto numbers tab and select percentage and select number of decimal places.
if you don't use the =IF and games played cell is 0 and error will result.
Try: (based on your example)
=(9/14)*100
=(9/14)*100
where nine is how copious you won and 14 is how many you played. In a form it'd look something close to:
=(A1/A2)*100
You have to own *100 in within, otherwise you will get merely a point number ( 9 / 14 = 0.6428 ).
If it comes out in the form as #######, after you need to constrict how many numbers come after the decimal point because 9 / 14 is a pretty immense number (e.g., 64.28% or just 64%).
Try here for info
http://www.techtutorials.net/
http://www.theeldergeek.com/
More Questions and Answers...