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 <

[hidden email]> wrote:

From: Zed <

[hidden email]>

Subject: [libreoffice-users] Formulas...

To:

[hidden email]
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:

[hidden email]
Problems?

http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:

http://wiki.documentfoundation.org/NetiquetteList 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:

[hidden email]
Problems?

http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:

http://wiki.documentfoundation.org/NetiquetteList archive:

http://listarchives.libreoffice.org/global/users/All messages sent to this list will be publicly archived and cannot be deleted