LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
winnieluvpooh
 
Posts: n/a
Default percentage not working right


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting percentage signs in Excel Romany Excel Discussion (Misc queries) 3 June 1st 05 07:02 PM
Working time and days Nortos Excel Worksheet Functions 5 May 6th 05 04:17 PM
Working time and days Nortos Excel Discussion (Misc queries) 1 May 6th 05 03:47 PM
Trace Dependents and Precedents not working Manish Excel Worksheet Functions 0 April 11th 05 09:39 PM
percentage of sales Kay LJ Excel Worksheet Functions 2 January 11th 05 01:38 AM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"