[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
forumboy
General User

Joined: 09 Apr 2005
Posts: 17

 Posted: Mon Apr 11, 2005 7:09 am    Post subject: HELP! How to copy formula in a smart way Hi all, I got a problem here. Say below is my data A B C Item Quantity % 1 a1 23 2 b1 15 3 c1 10 4 d1 29 5 e1 17 6 Total 94 To get the percentage, instead of enter =B1/B6 on row 1, =B2/B6 in row, etc Is there a better way that i can copy and paste or a macro that can simplified this issue. Imange if i have 1000 rows, very time consuming even copy and paste. Thank you.
8daysaweek.co.uk
Super User

Joined: 29 Nov 2003
Posts: 2130
Location: UK

 Posted: Mon Apr 11, 2005 7:43 am    Post subject: Hi forumboy, I don't really understand your example data, which numbers are you dividing to get your %? Assuming you want the percentage of value 23 (Cell C2) out of the total 94 (Cell C7) then =sum(c2/c7) would be a way of doing this. If you want to copy the formula down, simply use an absolute reference so that the formula becomes: =sum(c2/c\$7). Copy this down to the next row and the formula will be: =sum(c3/c\$7) (C\$7 hasn't changed). http://www.8daysaweek.co.uk/forums/viewtopic.php?p=233#233 HTH ,_________________James www.8daysaweek.co.uk - A User-Focused OOo site
forumboy
General User

Joined: 09 Apr 2005
Posts: 17

 Posted: Mon Apr 11, 2005 7:53 am    Post subject: Dear 8daysaweek Thanks for the info. Thats actually what i want to know. How to use absolute reference in formula. Thanks a lot.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum