Hi

I am having a problem with a spreadsheet.

Basically i have 4 cells each having numbers in it. What i want is for
each cell to show a percentage and not a number.

Ie. Cell 1 Cell 2 Cell 3 Cell 4

17 17 17 17

Rather than showing 17 points in each cell it should show 25%.

It is a sports spreadsheet where each cell in a each round will score
3,2,1 or 0.

so after the first round it could look like

cell 1 cell 2 cell 3 cell 4

2 3 1 0


but i would like the 2,3,1,0 to show as %

Thanks


--
mark evans
------------------------------------------------------------------------
mark evans's Profile: http://www.excelforum.com/member.php...o&userid=35760
View this thread: http://www.excelforum.com/showthread...hreadid=555358

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