View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_602_] Leith Ross[_602_] is offline
external usenet poster
 
Posts: 1
Default Percentage in a cell


Hello Mark,

Do you save the number of rounds in another cell or is this based on
100 as the maximum number of rounds?

The percentage can calculated in 2 ways..
1) Percent = Current Points / Total Rounds * 3
2) Percent = Current Points / 100

You can set the Number Format of the cell to Percentage if you want the
number displayed with the percent sign and a specfic number of digits
after the decimal point.

E.g. 25.00%

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=555358