Hi :) Do you need both parts of D$ to stay fixed? $D keeps the D part fixed and then $4 keeps the 4 part fixed so you need
=E10/$D$4 (I think) Regards from Tom :) --- On Thu, 10/5/12, Zed <z...@zed.net.nz> wrote: From: Zed <z...@zed.net.nz> Subject: [libreoffice-users] Formulas... To: users@global.libreoffice.org Date: Thursday, 10 May, 2012, 0:03 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: users+h...@global.libreoffice.org 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 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
