Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I have a 21 column worksheet. Once a month the managers send in there evolutions. Once they come in I mark them as complete and then add up the number that we received and come up with the % that is complete for the month. I finally made this in an excel spearsheet, but the % calulations comes out wrong. example: if we had 6 out of 21 come in then the percentage should be 30%. Well it comes back as 600%. I have tried to fix it, but it won't work. What am I doing wrong? winnie is ![]() -- winnieluvpooh ------------------------------------------------------------------------ winnieluvpooh's Profile: http://www.excelforum.com/member.php...o&userid=24509 View this thread: http://www.excelforum.com/showthread...hreadid=381042 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
percentage of sales | Excel Worksheet Functions |