Re: I need some help
Disregard my previous reply. You should use brackets as in =(A1-71)/5 - sorry. John van Barneveld -- Original Message -- From: "Suzanna Reiff" To: users@openoffice.apache.org Sent: 26/10/2017 3:15:05 AM Subject: I need some help I want to construct a document. It has fiver columns : 1. base number 2. I need to subtract '71' from the number in column 1. then : 3. I need to divide the result of columns 1 and 2 by "5' 4 I need to divide the result of columns 1 and 2 by "8" 5. I need to divide the result of columns 1 and 2 by "11' Suzanna Reiff suzannare...@aol.com --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I need some help
John van Barneveld -- Original Message -- From: "Suzanna Reiff" To: users@openoffice.apache.org Sent: 26/10/2017 3:15:05 AM Subject: I need some help I want to construct a document. It has fiver columns : 1. base number {A1} 2. I need to subtract '71' from the number in column 1. then : 3. I need to divide the result of columns 1 and 2 by "5' {=A1-71/5} 4 I need to divide the result of columns 1 and 2 by "8" {=A1-71/8} 5. I need to divide the result of columns 1 and 2 by "11' {=A1-71/11} Suzanna Reiff suzannare...@aol.com --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I need some help
On 2017-10-25 13:15, Suzanna Reiff wrote: I want to construct a document. Spreadsheet document? It has fiver columns : 1. base number 2. I need to subtract '71' from the number in column 1. then : So you need to set column B to contain what is in Column A and subtract 71? I am really curious what your application is... So you need to do something like "=A1 - 71" in to cell B1. 3. I need to divide the result of columns 1 and 2 by "5' Do you mean that column C must contain (A1 - 71) / 5, and you need to pull the value from column B? 4 I need to divide the result of columns 1 and 2 by "8" 5. I need to divide the result of columns 1 and 2 by "11' Suzanna Reiff suzannare...@aol.com Is this for a class, or do you simply need to create some data for your own personal use? Are you trying to use regular formulas, or an array formula?
I need some help
I want to construct a document. It has fiver columns : 1. base number 2. I need to subtract '71' from the number in column 1. then : 3. I need to divide the result of columns 1 and 2 by "5' 4 I need to divide the result of columns 1 and 2 by "8" 5. I need to divide the result of columns 1 and 2 by "11' Suzanna Reiff suzannare...@aol.com
Re: I need some help. Please help me.
On 15-Feb-16 04:27, suzannare...@aol.com wrote: 1. How do I get my current Lotus Approach file into Open Office 2. How do I create different reports in Open Office? Depend on the data and what you like to achieve. Hence giving an example of the data and what the report should look like will help us to answer your question. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I need some help. Please help me.
On Sun, 14 Feb 2016 12:27:36 -0500 suzannare...@aol.com wrote: > 1. How do I get my current Lotus Approach file into Open Office > > 2. How do I create different reports in Open Office? 1. I found this on converting Lotus Approach. It converts to Excel format; OpenOffice can read Excel files, so you can read these and convert into a database format supported by OpenOffice. https://bigmikeydread.wordpress.com/2012/04/17/converting-lotus-approach-apr-to-excel-or-other-database-files-music-spreadsheet-win7/ 2. Beyond my immediate knowledge. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
I need some help. Please help me.
1. How do I get my current Lotus Approach file into Open Office 2. How do I create different reports in Open Office?
I need some help
I have a Lotus Approach file that I need to make 6 six reports from. How do I do that ? Please help me. Suzanna Reiff 6394 Scorpio Ave North Port, Fl 34287 suzannare...@aol.com