LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I use a percentage formula?

Currently I am working on an assignment and need to turn a whole column
(approx. 153 cells) into a individual percentages of one cell. Every time I
tried to use a formula I either got 0 or DIV#0. I was wondering if there was
a formula I could create on my own so that I can drag thru the entire column.
I even tried to fool around with the '$' in the cells and that was
unsuccessful. I was also wondering if it had to do with the fact the numbers
in the cell also originate from formulas? Thanks


Sample #s and they need to be %s of 14,500,698

1,400,000
870,000
590,000
565,000
470,000
439,000
429,650
425,000
424,791
419,475
383,000
342,500
315,000
300,000
275,000
259,167
235,000
235,000
229,938
220,000
210,000
196,000
190,000
180,000
177,000
176,800
170,000
158,333
150,000
140,631
130,000
125,000
120,000
116,000
109,000
100,000
100,000
100,000
90,000
90,000
90,000
80,000
80,000
80,000
80,000
75,000
75,000
75,000
70,000


MeursaultO
 
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
Percentage Formula KristiM Excel Worksheet Functions 5 May 27th 08 11:33 PM
Percentage Formula Help Steph Excel Worksheet Functions 1 February 24th 08 09:49 PM
Percentage Formula Kittykat8181 Excel Discussion (Misc queries) 2 November 28th 05 07:11 PM
percentage formula Gina Excel Worksheet Functions 2 October 21st 05 09:05 PM
Percentage Formula George Excel Worksheet Functions 2 April 9th 05 06:51 PM


All times are GMT +1. The time now is 01:16 AM.

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

About Us

"It's about Microsoft Excel"