Remember Me?

#1
January 4th 07, 10:57 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 2
Want a percentages of a single cell divided by a column of cells

Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

#2
January 4th 07, 11:07 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221
Want a percentages of a single cell divided by a column of cells

Hazarding a guess that
the dollar sign (\$) is what you're after here

Maybe you mean something like this:

You've got numbers in A1:A9, with the total in A10
[ in A10: =SUM(A1:A9) ]

Then in B1: =A1/A\$10

B1 is formatted as percentage,
and copied down to B10
to return the corresponding percentages

The \$ sign in A\$10 will fix it to the row10 where the total cell is in col
A. Hence this part won't change when B1 is copied down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

#3
January 4th 07, 11:09 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856
Want a percentages of a single cell divided by a column of cells

You need to make the cell reference for the second cell absolute - you
use the dollar symbol \$ for this, for example:

=A2/A\$1

When you copy this down it will become:

=A3/A\$1
=A4/A\$1

etc.

Hope this helps.

Pete

dbog wrote:

Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

#4
January 5th 07, 04:45 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 2
Want a percentages of a single cell divided by a column of cel

Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting.

"Max" wrote:

Hazarding a guess that
the dollar sign (\$) is what you're after here

Maybe you mean something like this:

You've got numbers in A1:A9, with the total in A10
[ in A10: =SUM(A1:A9) ]

Then in B1: =A1/A\$10

B1 is formatted as percentage,
and copied down to B10
to return the corresponding percentages

The \$ sign in A\$10 will fix it to the row10 where the total cell is in col
A. Hence this part won't change when B1 is copied down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Want the symbol to make the formula repeat in each new cell, but keep the
second cell the same. Thought it was a karat, but that doesn't work.

#5
January 5th 07, 11:37 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 9,221
Want a percentages of a single cell divided by a column of cel

You're welcome !
Thanks for feeding back to us ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbog" wrote in message
...
Yes, that's it!! Thanks to both of you so much. It saves me a ton of
copying and pasting.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post LenS Excel Discussion (Misc queries) 18 January 4th 07 12:53 AM Trish Excel Discussion (Misc queries) 3 November 9th 06 09:17 PM [email protected] Excel Discussion (Misc queries) 1 August 16th 06 01:18 PM Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM

All times are GMT +1. The time now is 03:17 AM.