LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JP
 
Posts: n/a
Default calculate percentage

Hi there all,

Can someone please offer assistance. I just can't seem to work this out and
its a bit of a dive into the program to have perform this function so i can
export the result back into another program.

I have in column A a list of numbers. I need for excel to calculate .95888
or 95.888% of the value of A1 and put the answer into B1.

I have some 800 entries...A1, A2, A3 etc...A800 and would like it to
calculate each and place the answer into the corresponding B1, B2, B3
etc...B800.

That's it. Any explanation of how to do this would be fantastic. I use
version 2002.

Thanks to all,

JP


 
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
How to calculate a percentage formula with existing data? MeaganNW Excel Worksheet Functions 4 September 8th 08 08:39 AM
Forumla to calculate a percentage julie regan Excel Discussion (Misc queries) 0 January 20th 05 07:53 PM
How do I create a formula to calculate the average percentage rat LD Excel Worksheet Functions 5 January 13th 05 06:17 PM
Excel 2003 -- I need to know how to calculate a percentage of uni. Kelly Excel Discussion (Misc queries) 1 December 11th 04 03:10 PM
calculate percentage of two cells Suzie Excel Worksheet Functions 4 December 3rd 04 05:27 PM


All times are GMT +1. The time now is 08:23 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"