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