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. |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com