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, > > > Zed > Desk - A very large wastebasket with drawers. > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
