[users] Re: separated columns

2010-02-08 Thread Gene Kohlenberg
On 2/8/2010 10:29 PM, Gene Kohlenberg wrote: On 2/8/2010 9:27 PM, Walter Hildebrandt wrote: I am confused. IOn your last reply, what is the difference between IF(OR and IF(AND. Why was there just the ;3 at the end of the IF(AND but a ;2;"emt" at the end of the IF(OR On Mon, Feb 8, 2010 at 6:44

[users] Re: separated columns

2010-02-08 Thread Gene Kohlenberg
On 2/8/2010 9:27 PM, Walter Hildebrandt wrote: I am confused. IOn your last reply, what is the difference between IF(OR and IF(AND. Why was there just the ;3 at the end of the IF(AND but a ;2;"emt" at the end of the IF(OR On Mon, Feb 8, 2010 at 6:44 PM, Gene Kohlenberg wrote: On 2/8/2010 6:2

Re: [users] Re: separated columns

2010-02-08 Thread Walter Hildebrandt
I am confused. IOn your last reply, what is the difference between IF(OR and IF(AND. Why was there just the ;3 at the end of the IF(AND but a ;2;"emt" at the end of the IF(OR On Mon, Feb 8, 2010 at 6:44 PM, Gene Kohlenberg wrote: > On 2/8/2010 6:28 PM, Walter Hildebrandt wrote: > >> The formula

Re: [users] error message when saving documents under file

2010-02-08 Thread John Jason Jordan
On Mon, 8 Feb 2010 11:57:42 -0600 "Loyd Patterson" dijo: >Since installing Open Office I sometimes get an error message when I >try to save a document under file. When it first occurred I tried >uninstalling Open Office and it stopped the problem. I then >reinstalled and had no problem for severa

[users] Re: Open office and opening a word document

2010-02-08 Thread Mark C. Miller
On Thu, 04 Feb 2010 22:49:13 +1300, Michael Adams wrote: > On Thursday 04 February 2010 11:02, Linda Lowther wrote: >> Hello: >> >> Thank you very much for open office. I need to open and print a >> presentation for work that is in created in Word. When I try to open >> the completed presentation

[users] Re: separated columns

2010-02-08 Thread Gene Kohlenberg
On 2/8/2010 6:28 PM, Walter Hildebrandt wrote: The formula worked except 2 appeared where emt should appear On Mon, Feb 8, 2010 at 3:54 PM, Gene Kohlenberg wrote: On 2/8/2010 5:26 PM, Walter Hildebrandt wrote: How would the following be done? Cells A1, B1, D1, E1 have numbers in them that m

[users] Re: Application

2010-02-08 Thread Mark C. Miller
On Mon, 08 Feb 2010 07:54:33 -0800, drscott398 wrote: > I have tried to use the download arrangement today, even attending to > the ' survey ' but when clicking on download the time clock does not > move beyond 56 minutes and 30 seconds ! ? > > Can you please advise.Regards think I hit reply

[users] Re: Application

2010-02-08 Thread Mark C. Miller
On Mon, 08 Feb 2010 07:54:33 -0800, drscott398 wrote: > I have tried to use the download arrangement today, even attending to > the ' survey ' but when clicking on download the time clock does not > move beyond 56 minutes and 30 seconds ! ? > > Can you please advise.Regards Not quite sure he

Re: [users] separated columns

2010-02-08 Thread Walter Hildebrandt
The confusing part is that the first IF(OR with the seems to work by itself. The second IF(OR with the < works with the IF(AND and both the IF(OR and IF(AND seem to be related to the 0 at the end of the formula. On Mon, Feb 8, 2010 at 4:20 PM, Walter Hildebrandt wrote: > Thank you, John

Re: [users] Re: separated columns

2010-02-08 Thread Walter Hildebrandt
The formula worked except 2 appeared where emt should appear On Mon, Feb 8, 2010 at 3:54 PM, Gene Kohlenberg wrote: > On 2/8/2010 5:26 PM, Walter Hildebrandt wrote: > >> How would the following be done? >> >> Cells A1, B1, D1, E1 have numbers in them that may be greater than 0 >> (vero) >> or les

Re: [users] separated columns

2010-02-08 Thread Walter Hildebrandt
Thank you, Johnny. The 2nd one worked great. I am trying to understand the formula so that I can modify it for different conditions. What is the reason there is both IF(or and IF(and used in the formula? On Mon, Feb 8, 2010 at 3:51 PM, Johnny Rosenberg wrote: > 2010/2/8 Johnny Rosenberg : > >

[users] Re: separated columns

2010-02-08 Thread Gene Kohlenberg
On 2/8/2010 5:26 PM, Walter Hildebrandt wrote: How would the following be done? Cells A1, B1, D1, E1 have numbers in them that may be greater than 0 (vero) or less than 0 In cell Z1, if all the four cells have numbers greater than 0, 3 appears. In cell Z1, if any of the four cells have a number

Re: [users] separated columns

2010-02-08 Thread Johnny Rosenberg
2010/2/8 Johnny Rosenberg : > 2010/2/8 Walter Hildebrandt : >> How would the following be done? >> >> Cells A1, B1, D1, E1 have numbers in them that may be greater than 0 (vero) >> or less than 0 >> >> In cell Z1, if all the four cells have numbers greater than 0, 3 appears. >> In cell Z1, if any o

Re: [users] separated columns

2010-02-08 Thread Johnny Rosenberg
2010/2/8 Walter Hildebrandt : > How would the following be done? > > Cells A1, B1, D1, E1 have numbers in them that may be greater than 0 (vero) > or less than 0 > > In cell Z1, if all the four cells have numbers greater than 0, 3 appears. > In cell Z1, if any of the four cells have a number less t

[users] separated columns

2010-02-08 Thread Walter Hildebrandt
How would the following be done? Cells A1, B1, D1, E1 have numbers in them that may be greater than 0 (vero) or less than 0 In cell Z1, if all the four cells have numbers greater than 0, 3 appears. In cell Z1, if any of the four cells have a number less than 0, 2 appears However, in cell Z1, if a

Re: [users] error message when saving documents under file

2010-02-08 Thread jonathon
Loyd Patterson wrote: > Since installing Open Office I sometimes get an error message when I try to > save a document under file. What is the error message that the system generates? jonathon - To unsubscribe, e-mail: users-un

[users] borders

2010-02-08 Thread Christine Hanley
I would like to know if it is possible to use "border art" such as I am able to use with Microsoft Works or Word. Please respond Christine

[users] Application

2010-02-08 Thread drscott398
I have tried to use the download arrangement today, even attending to the ' survey ' but when clicking on download the time clock does not move beyond 56 minutes and 30 seconds ! ? Can you please advise.Regards

[users] error message when saving documents under file

2010-02-08 Thread Loyd Patterson
Since installing Open Office I sometimes get an error message when I try to save a document under file. When it first occurred I tried uninstalling Open Office and it stopped the problem. I then reinstalled and had no problem for several days but now the problem has returned. If you can provide

Re: [users] Test 2

2010-02-08 Thread Tanstaafl
David B Teague wrote: >> Please don't invade the inboxes of thousands of people just because you >> think you might have a problem posting. >> >> That is really rude. > No, it is you who is being rude. not... > First, there is no way to test posting to see whether he can post here > other than t