D4 and E10 are cells not columns
as a result it is unclear what you mean by "copy E10 down so that D4 is
the constant." What exactly are yo trying to accomplish?
On 5/9/12 3:03 PM, Zed wrote:
It is so long since I used the Formula I'm looking for that I have forgotten
what it is. Here is my problem
I have a column, say, D4 in which I have a constant figure, say, 100
Another column E10 , let's call it Production, contains a figure of, say, 79
I can establish that 79 is 79% of actual production by entering the formula
=E10/D4 and then Formatting the expression to Percentage. But I cannot
remember the formula to copy E10 down so that D4 is the constant.
I have tried E/10/D4, E10/$D4, $E10/D4, $E10/$D4 and then Filled Down
without obtaining the correct answer.
If anyone on the list is able to help me, I'd be most gratefu,
Desk - A very large wastebasket with drawers.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy