Re: [libreoffice-users] Formulas...

[Tom Davies <tomdavies04@yahoo.co.uk>]

Hi :)
[bows]  Thanks :)

It's sometimes fastest to ask the list but while you are waiting to look through documentation
http://wiki.documentfoundation.org/Documentation/Publications

If you find the answer before getting a reply it's best to post the answer into the thread so that people can focus more on things that do need to be solved.  
Regards from
Tom :)



--- On Fri, 11/5/12, Zed <zed@zed.net.nz> wrote:

From: Zed <zed@zed.net.nz>
Subject: Re: [libreoffice-users] Formulas...
To: users@global.libreoffice.org
Date: Friday, 11 May, 2012, 7:39

Zed <zed@zed.net.nz> 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,

Thank you Miroslave Zalewski, Tom Davis and Johnny Rosenberg for suggesting
suitable solutions.  It is verr much appreciated.

Zed
-- 
Zed
A Closed Mouth Gathers No Foot  

-- 
For unsubscribe instructions e-mail to: users+help@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+help@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