A formulae in Excell to work out %?

Question

I run a pool team, i need 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

Answer 1

=IF((games won cell),games won cell/games played cell,0)
then 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.

Answer 2

=(9/14)*100

where nine is how many you won and 14 is how many you played. In a form it'd look something like:

=(A1/A2)*100

You have to have *100 in there, otherwise you will get just a point number ( 9 / 14 = 0.6428 ).

If it comes out in the form as #######, then you need to limit how many numbers come after the decimal point because 9 / 14 is a pretty large number (e.g., 64.28% or just 64%).

Answer 3

Try: (based on your example)

=(9/14)*100

Answer 4

Try here for info
http://www.techtutorials.net/

http://www.theeldergeek.com/