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
Johnny Rosenberg gurus.knu...@gmail.com:
2010/2/8 Walter Hildebrandt wh2...@gmail.com:
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
The formula worked except 2 appeared where emt should appear
On Mon, Feb 8, 2010 at 3:54 PM, Gene Kohlenberg
gene.kohlenb...@toast.netwrote:
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
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 wh2...@gmail.com 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
gene.kohlenb...@toast.netwrote:
On 2/8/2010 6:28 PM, Walter Hildebrandt
You did an outstanding job in answering my questions. Your use of the
numbers, the letters, and the // put the information in a way that is was
understandable. Thank you
Walter
On Fri, Nov 13, 2009 at 1:01 PM, Harold Fuchs
hwfa.openoff...@googlemail.com wrote:
Walter Hildebrandt wrote:
I
, Nov 12, 2009 at 4:20 AM, Harold Fuchs
hwfa.openoff...@googlemail.com wrote:
2009/11/11 Walter Hildebrandt wh2...@gmail.com
I am trying to learn the syntax of the IF formula.so I can modify the
formula into a new, modified formula.
There are three opened brackets (ISBLANK(A1), (A1=0
I have the following formula:
IF*(**ISBLANK(A1)*;*Empty*;IF*(A1=0*;*no Div*;A1-40+STYLE(IF*(A140*;
RedText
The syntax of an IF consists of three components:
1.
*The condition*
2.
*What to do if the condition is true*
3.
*What to do if the condition is false*
What is
On Wed, Nov 11, 2009 at 10:00 AM, Gene Young n2...@cfl.rr.com wrote:
Walter Hildebrandt wrote:
I have the following formula:
IF*(**ISBLANK(A1)*;*Empty*;IF*(A1=0*;*no Div*;A1-40+STYLE(IF*(A140*;
RedText
The syntax of an IF consists of three components:
1.
*The condition*
2
On Wed, Nov 11, 2009 at 11:38 AM, Gene Young n2...@cfl.rr.com wrote:
Walter Hildebrandt wrote:
On Wed, Nov 11, 2009 at 10:00 AM, Gene Young n2...@cfl.rr.com wrote:
Walter Hildebrandt wrote:
I have the following formula:
IF*(**ISBLANK(A1)*;*Empty*;IF*(A1=0*;*no
Div*;A1-40+STYLE
*/in your formula. I
think ist clear what happen.
Franz
Walter Hildebrandt schrieb:
I have the following formula:
IF*(**ISBLANK(A1)*;*Empty*;IF*(A1=0*;*no Div*;A1-40+STYLE(IF*(A140*;
RedText
The syntax of an IF consists of three components:
1.
*The condition*
2
hwfa.openoff...@googlemail.com
2009/11/9 Walter Hildebrandt wh2...@gmail.com
What does 0 mean and what is its effect in various condition?
In a numeric context, 0 means zero.
If you try to treat *text* in a numeric context then the text will
usually
be treated as zero
is using a very large
spreadsheet. I use Writer and have more or less figured out how to use
Writer to my satisfaction.
Walter
On Mon, Nov 9, 2009 at 10:31 AM, Harold Fuchs
hwfa.openoff...@googlemail.com wrote:
Walter Hildebrandt wrote:
You ask Why don't you use the Conditional Formatting
What does 0 mean and what is its effect in various condition?
For example : When I got the formula =A1-40+IF(A140;STYLE(RedText);0), I
was told “The STYLE function always returns 0, so the formula is
mathematically
equal to A1-40+0” What is effect of the 0 at the end of the formula?
For
?
On Sat, Nov 7, 2009 at 12:34 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
2009/11/7 Johnny Rosenberg gurus.knu...@gmail.com:
2009/11/6 Walter Hildebrandt wh2...@gmail.com:
Cell A1 has a number.
Cell B1 is to have how much less, or much more, A1 is than 40.
When A1 is less than 40
but they are actually
percent numbers. Is there a way for the numbers in column B to have the %
signed included? The B column has just the number without a % sign.
On Sat, Nov 7, 2009 at 12:10 PM, Brian Barker b.m.bar...@btinternet.comwrote:
At 11:21 07/11/2009 -0700, Walter Hildebrandt wrote:
I created
meaningless or bad.
Between you and the others, a great job was done in solving my problems.
Walter
On Sat, Nov 7, 2009 at 2:06 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
2009/11/7 Walter Hildebrandt wh2...@gmail.com:
Yes, your formula does work. The colors are correct.
I added
up in columns D and E and compacting as each row is Pasted.
Walter
On Tue, Oct 27, 2009 at 12:16 PM, Johnny Rosenberg
gurus.knu...@gmail.comwrote:
Well, the simple answer would probably be to sort columns D and E.
Johnny Rosenberg
2009/10/26 Walter Hildebrandt wh2...@gmail.com:
My
.
The formula would say if there was a name in column B and C then copy A and
B into D and E.
Walter
On Tue, Oct 27, 2009 at 2:30 PM, Walter Hildebrandt wh2...@gmail.comwrote:
Johnny, you are correct that sorting does compact columns D and E. The
problem still remains how to get the data out
My question is, how can I do the following?
There are 200 rows involved. The following explains the question.
Cell A1 has the number 1 in it, cell A2 has 2 in it, cell A3 has 3, cell A4
has 4
Cells B1 has the name name1 in it, cell B2 has name2 in it, cell B3 has
name3, cell B4 has name4
Cell
In a cells of a column the following formula is entered.
IF(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0));;VLOOKUP(D4;$B$4:$B$200;1;0))
This formula produces all the entries that are in both the B column and the
D column.
What formula would produce only the entries that are in the D column but *
not* in
, Brian Barker b.m.bar...@btinternet.comwrote:
At 20:35 25/10/2009 -0600, Walter Hildebrandt wrote:
In a cells of a column the following formula is entered.
IF(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0));;VLOOKUP(D4;$B$4:$B$200;1;0))
This formula produces all the entries that are in both the B column
When I in what I think is the main Base window there is a pain on the left
named *Database* and there are two pains to the right. The top pain is
named *Tasks* and the bottom pain is named *Tables*. When I click on
the *Tables
icon* that is in the left paid, *Table1* appears in the *Tables*
not appear on the screen.
I prefer to use Copy and Paste instead of Drag Drop
Walter
On Fri, Oct 23, 2009 at 11:20 AM, Drew Jensen
usersl...@paintedfrogceramics.com wrote:
Walter Hildebrandt wrote:
When I in what I think is the main Base window there is a pain on the
left
named *Database
Using OOo 3.1 on a WindowsXP computer. There is a spreadsheet and a table
in Base, both of which have two columns with the same headings. How can the
data from the two columns in the spreadsheet be copied into the Base
table? From time to time the coping from the spreadsheet into the Base
table
.
On Thu, Oct 22, 2009 at 5:59 PM, Drew Jensen
usersl...@paintedfrogceramics.com wrote:
Walter Hildebrandt wrote:
Using OOo 3.1 on a WindowsXP computer. There is a spreadsheet and a table
in Base, both of which have two columns with the same headings. How can
the
data from the two columns
I still have the same problem. Every thing works properly until I Open
Query 1 there are four columns that have titles. Week, Client, Amount and
Stamp
If I do the steps slightly different I get Value, Name, Stamp, and ID.
Nothing is in the Value, Name, or Stamp columns. In the ID column there
In Windows, when the F4 key is pressed, a Beamer appears on the screen. I
have created a number of databases and deleted the databases from my
computer. The databases still appear in the Beamer but the databases are
not on my computer. How do I delete the databases from the Beamer?
Yes it is in Writer and it is also in Calc. In my case i want to remove
somethings in the Beamer that are meaningless.
On Sat, Oct 10, 2009 at 11:34 AM, Brian Barker b.m.bar...@btinternet.comwrote:
At 11:17 10/10/2009 -0600, Walter Hildebrandt wrote:
In Windows, when the F4 key is pressed
I have successfully gone down to where the instructions say GO TO THE
QUERIES SECTION. I could not find the Queries section to create a new query
in SQL view
On Mon, Oct 5, 2009 at 2:28 PM, Andreas Saeger saege...@onlinehome.dewrote:
Walter Hildebrandt wrote:
On Mon, Oct 5, 2009 at 9:49 AM
On Mon, Oct 5, 2009 at 2:56 AM, Andreas Saeger saege...@onlinehome.dewrote:
So we have another important hint about what you are doing acutally.
- I guess, you copy HTML-tables out of web-pages.
I have a software program that does a Data Export to my desktop. A
Microsoft Excel 97-2003
On Mon, Oct 5, 2009 at 9:49 AM, Andreas Saeger saege...@onlinehome.dewrote:
Walter Hildebrandt wrote:
On Mon, Oct 5, 2009 at 2:56 AM, Andreas Saeger saege...@onlinehome.de
wrote:
So we have another important hint about what you are doing acutally.
- I guess, you copy HTML-tables out
:
2009/10/3 Brian Barker b.m.bar...@btinternet.com:
At 13:22 02/10/2009 -0600, Walter Hildebrandt wrote:
Column A in the spreadsheet is column LC. Column B in the spreadsheet
is
column LE. Column C in the spreadsheet is LF.
The following formula was put into cell LF1
=IF(ISNA
, Andreas Saeger saege...@onlinehome.dewrote:
Walter Hildebrandt wrote:
Another condition is that both columns A and B are compacted at the top
of
the columns.
If there are 10 words in either column A or B, then these words will
appear
in rows 1 through 10.
If there are 10 words in column
In column A there is a list of words. Anywhere from 10 to 100 rows are
involved in column A. In column B I have an other list of words. Anywhere
from 10 to 100 rows are involved in column B
How can a list of all the words that appear in both A and B columns appear
in column C?
For example if
Another condition is that both columns A and B are compacted at the top of
the columns.
If there are 10 words in either column A or B, then these words will appear
in rows 1 through 10.
If there are 10 words in column A and 100 words in column B, then column A
will have the words in rows 1
...@gmail.comwrote:
2009/10/2 Walter Hildebrandt wh2...@gmail.com:
In column A there is a list of words. Anywhere from 10 to 100 rows are
involved in column A. In column B I have an other list of words.
Anywhere
from 10 to 100 rows are involved in column B
How can a list of all the words
How is the following done?
Cell A1 has a date
Cell B1 is to have the date that is in A1 but the date in B1 is three days
latter that the date in A1
Cell C1 is to have the date that is in B1 but the date in C1 is eight days
latter that the date in B1
All the cells are formatted as Dec 31, 99
I do not have an asterisks in the formula. Somehow the asterisks was added
to what I said in the Email. When I enter =A1+3 in Cell B1, I get Jan 02,
00
On Tue, Sep 29, 2009 at 9:51 AM, Richard Detwiler rlsha...@aol.com wrote:
Walter Hildebrandt wrote:
How is the following done?
Cell A1
file and entered the information. So it might be helpful to see your actual
file (take out anything that might be confidential before sending it, of
course, or else just start up a new file and put in what you're talking
about in cells A1, B1, and C1.
Walter Hildebrandt wrote:
I do not have
Is it possible to do the following?
1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from a
website.
2. The number in Cell A1 is automatically moved to (copied to) cell B5
3. The number in Cell A2 is automatically moved to (copied to) cell B4
4. The number in Cell A3
I am using WindowsXP.
Wade, I do not understand. What do you mean by Site 1, Site 2 etc
Walter
On Sat, Sep 26, 2009 at 2:37 PM, Wade Smart w...@wadesmart.com wrote:
Walter Hildebrandt wrote:
Is it possible to do the following?
1. Cells A1, A2, A3, A4, and A5 get numbers
:57 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
2009/9/26 Walter Hildebrandt wh2...@gmail.com:
Is it possible to do the following?
1. Cells A1, A2, A3, A4, and A5 get numbers that are downloaded from a
website.
2. The number in Cell A1 is automatically moved to (copied to) cell
be
because what I wrote Jonny in regards unconscious thinking habits (Think
outside the box)
Walter
Denver Colorado
On Sat, Sep 26, 2009 at 3:15 PM, Brian Barker b.m.bar...@btinternet.comwrote:
At 14:32 26/09/2009 -0600, Walter Hildebrandt wrote:
Is it possible to do the following?
1. Cells A1
On Sat, Sep 26, 2009 at 3:02 PM, Wade Smart w...@wadesmart.com wrote:
Walter Hildebrandt wrote:
I am using WindowsXP.
Wade, I do not understand. What do you mean by Site 1, Site 2 etc
Walter
On Sat, Sep 26, 2009 at 2:37 PM, Wade Smart w...@wadesmart.com wrote:
Walter Hildebrandt wrote
The following formula works to give a Yes or a No in C1
IF(AND(A1=0;B1=0);Yes;No)
How can that formula be increased so that not only A1 and B1 is used but
that C1, D1 and E1 be included
In other words, what formula can be used when A1=0 and B1=0, and C1=0 and
D1=0 and E1=0 so that Yes or No
, 2009 at 10:02 AM, Brian Barker b.m.bar...@btinternet.comwrote:
At 09:39 23/08/2009 -0600, Walter Hildebrandt wrote:
Is there a formula that will do the following?
1 If A1 is empty, Emt appears in C1
2 If A1 is a negative number, Neg appears in C1
3 If A1 has a 0 (a zero), Zero appears
Is there a formula that will do the following?
1 If A1 is empty, Emt appears in C1
2 If A1 is a negative number, Neg appears in C1
3 If A1 has a 0 (a zero), Zero appeains in C1
4 If 1, 2, and 3, above, do not exists than C1 is the percentage by which
A1 is greater then B1
A spreadsheet has data in rows A through CX. Column W is a column with only
numbers. The complete spreadsheet is to be sorted by doing a Desending
Sort on column W. When the Sort is done only column W is sorted. Is there
some way to have all the columns sorted based on column W. For example
...@gmail.com wrote:
Walter Hildebrandt wrote:
A spreadsheet has data in rows A through CX. Column W is a column with
only
numbers. The complete spreadsheet is to be sorted by doing a Desending
Sort on column W. When the Sort is done only column W is sorted. Is
there
some way to have all
Brewster, I did not know there was a Sort choice under Data. I was using
the icons to do the sorting. Thank you for the help.
Walter
On Thu, Jul 9, 2009 at 10:08 PM, bg b...@fdi.us wrote:
On Thu, 2009-07-09 at 20:55, Walter Hildebrandt wrote:
Joe, when I select all the cells and then click
The 7. condition is corrected below. Disregard the 7. condition previously
sent.
2009/6/8 Walter Hildebrandt wh2...@gmail.com
The formula IF(OR(A1=;B1=);IF(OR(A10;B10);Neg,
Emt;Empty);IF(OR(B10;A10);Negative;IF(B10;(A1-B1)/B1;IF(A1=0;1;∞%
works well for the following 5 conditions
.
Good luck with whatever it is you are working on and with your learning.
Cheers,
Mark
2009/6/9 Walter Hildebrandt wh2...@gmail.com:
The 7. condition is corrected below. Disregard the 7. condition
previously
sent.
2009/6/8 Walter Hildebrandt wh2...@gmail.com
The formula
...@gmail.comwrote:
2009/6/8 Walter Hildebrandt wh2...@gmail.com:
Johnny, ignore my previous Reply to this Email. Your formula is working
as
it should.
I'm glad to hear that.
By the way, you know that you can hit Ctrl+F2 to input formulas in a
somewhat more guided way, don't you
The formula IF(OR(A1=;B1=);IF(OR(A10;B10);Neg,
Emt;Empty);IF(OR(B10;A10);Negative;IF(B10;(A1-B1)/B1;IF(A1=0;1;∞%
works well for the following 5 conditions below. Please add conditions 6
and 7 to the formula. I hope to compare the original formula to the new
formula and thereby learn
Johnny, I tested all the different possibilities and found, assuming I did
not make a mistake, there was one condition that did not work properly.
When A1 was empty and there was a negative number in B1, C1 had Empty. C1
should be Empty,Negative.
The following is some information I have gathered
Johnny, ignore my previous Reply to this Email. Your formula is working as
it should.
2009/6/7 Walter Hildebrandt wh2...@gmail.com
Johnny, I tested all the different possibilities and found, assuming I did
not make a mistake, there was one condition that did not work properly.
When A1
What formula would be used to meet the following conditions?
1) If both A1 and B1 are positive numbers, and A1 is greater than B1, get a
positive number, in C1. The number in C1 is the percentage by how much A1 is
greater that B1.
2) If both A1 and B1 are positive, and A1 is less than B1, get a
conditions below.
Kind regards
Johnny Rosenberg
2009/6/6 Walter Hildebrandt wh2...@gmail.com:
What formula would be used to meet the following conditions?
1) If both A1 and B1 are positive numbers, and A1 is greater than B1, get
a
positive number, in C1. The number in C1
Johnny;
OK, if A1 is positive and B1=0 it is C1 can have a oo with or without a
%
Walter
On Fri, Jun 5, 2009 at 5:38 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
2009/6/6 Walter Hildebrandt wh2...@gmail.com:
Johnny;
If there is a 0 (zero) it is considered to be a positive number
Rosenberg
2009/6/6 Johnny Rosenberg gurus.knu...@gmail.com:
2009/6/6 Walter Hildebrandt wh2...@gmail.com:
Johnny;
If there is a 0 (zero) it is considered to be a positive number. I
missed
this concept when I was using the words positive number.
Walter
Ok, and what about if A1
I am replying for a 2nd time since the first reply got to someone by mistake
called *O*
On Fri, Jun 5, 2009 at 5:38 PM, Johnny Rosenberg gurus.knu...@gmail.comwrote:
2009/6/6 Walter Hildebrandt wh2...@gmail.com:
Johnny;
If there is a 0 (zero) it is considered to be a positive number. I
On Fri, Jun 5, 2009 at 7:32 PM, Brian Barker b.m.bar...@btinternet.comwrote:
At 16:25 05/06/2009 -0600, Walter Hildebrandt wrote:
What formula would be used to meet the following conditions?
It is perhaps worth saying that the best way to learn about formulae and
spreadsheets may
Great job, Brian. The
=IF(AND(OR(A1=;B1=);OR(A1
0;B10));Negative/Empty;IF(OR(A1=;B1=);Empty;IF(OR(A10;B10);Negative;IF(B1=0;B
is zero!;(A1-B1)/B1
worked
Walter
On Fri, Jun 5, 2009 at 7:59 PM, Walter Hildebrandt wh2...@gmail.com wrote:
On Fri, Jun 5, 2009 at 7:32 PM, Brian Barker
, JOE Conner joeconner2...@gmail.com wrote:
Walter Hildebrandt wrote:
On Fri, Jun 5, 2009 at 7:32 PM, Brian Barker b.m.bar...@btinternet.com
wrote:
SNIP
Brian, you point is well taken. I have tried to find a manual to learn
about the various formula that can be used in OOo buy can
What formula can be used to do all of the following;
1) If A1 is a positive number that number will appear in B1
2) If A1 is 0 (a zero) that number will appear in B1
3) If A1 has a negative number that negative number will appear in B1
4) If A1 is empty then B1 will be empty
In A1 there can be any number from 1 through 100. In B1, how can I get the
difference between the A1 number and 90.
If the number in A1 is greater than 90, then the difference in B1 is a
positive number (For example if A1 is 91 then the number in B1 is 1. If the
number in A1 is 95 then the
Joe you are correct, Thank you. It works even when A1 is empty
On Wed, Jun 3, 2009 at 8:15 PM, JOE Conner joeconner2...@gmail.com wrote:
Mark Knecht wrote:
=IFERROR(A1-90)
On Wed, Jun 3, 2009 at 6:55 PM, Walter Hildebrandt wh2...@gmail.com
wrote:
In A1 there can be any number from 1
. Was this what you were originally
asking for?
Johnny Rosenberg
2009/6/2 Walter Hildebrandt wh2...@gmail.com:
Thanks to everyone who helped with this question.
The following is a summary I made for myself. This might be of interest
to
some.
=IF(OR(A10;B1=0);;(A1-B1)/B1)
Any time
Thanks to everyone who helped with this question.
The following is a summary I made for myself. This might be of interest to
some.
=IF(OR(A10;B1=0);;(A1-B1)/B1)
Any time there is -100% or a blank in C, *look at the As and the Bs* to see
what in the As and Bs. This is because there are various
Thank you, Keith, the complicated formula
=IF(A10;;IF(B10;;(A1-B1)/B1) works great.
Walter
On Sat, May 30, 2009 at 11:29 PM, Keith N. McKenna
keith.mcke...@comcast.net wrote:
Walter;
Sorry about that I misread your original message. Let me see if I have
this straight. In the
In Calc I am using the following formula in cell C1
=A1-B1)/B1
Is there some way to get an empty C1 cell when there is a negative number in
either A1 or B1?
...@comcast.net
wrote:
Walter Hildebrandt wrote:
In Calc I am using the following formula in cell C1
=A1-B1)/B1
Is there some way to get an empty C1 cell when there is a negative number
in
either A1 or B1?
Walter;
Put this if statement into cell C1. =IF(A1-B1 0;0;A1-B1) which says
[?] )
On Thu, Apr 23, 2009 at 9:17 PM, John Boyle jbo...@harbornet.com wrote:
Walter Hildebrandt wrote:
Is there a voice recognition capability that can be used with Writer?
(Can be used to add text to a Writer document?)
To Walter Hildebrand: Yes, there are two different products. Both are
owned
Is there a voice recognition capability that can be used with Writer?
(Can be used to add text to a Writer document?)
Does anyone know if there is a hand held copying device that can copy text
and paste that text into a Writer text file and be able to edit that text in
the Writer text file?
Harold, I am impressed. I did not make my question clear but you still came
up with the correct solution. The last ABS worked. Thank you.
Walter
On Fri, Apr 17, 2009 at 10:26 AM, Harold Fuchs
hwfa.openoff...@googlemail.com wrote:
2009/4/17 Walter Hildebrandt wh9...@gmail.com
Putting
at 12:16 AM, NoOp gl...@sbcglobal.net wrote:
On 04/10/2009 06:19 PM, NoOp wrote:
On 04/10/2009 11:56 AM, Walter Hildebrandt wrote:
using 3.0 with WindowsXP. There is a PDF file on my desktop that I
would
like to copy the contents into a OOo Writer file and be able to edit the
contents
...@sbcglobal.net wrote:
On 04/10/2009 06:19 PM, NoOp wrote:
On 04/10/2009 11:56 AM, Walter Hildebrandt wrote:
using 3.0 with WindowsXP. There is a PDF file on my desktop that I
would
like to copy the contents into a OOo Writer file and be able to edit the
contents in the OOo Writer file
using 3.0 with WindowsXP. There is a PDF file on my desktop that I would
like to copy the contents into a OOo Writer file and be able to edit the
contents in the OOo Writer file. Can this be done?
I have several large spreadsheets that are exactly the same except cells
have different numbers. I would like to create a new spreadsheet to
compare the data in just some of the cells of the original spreadsheets
As a example I would like the new spreadsheet to show the numbers from the
A1
In Calc there is the Name Box that has a pull-down menu in which individual
cells can be named. Is there some way in Writer to make a pull-down menu
that has a list of words. When a particular word is selected, the cursor
goes to that word. The words in the pull-down menu would act like a Table
I have a large spreadsheet. Is there a Go To command to go to a specific
cell. For example, Is there some way to name a call and then use that
name in a Go To command so that named cell appears on the screen?
...@btinternet.comwrote:
At 15:41 08/03/2009 -0600, Walter Hildebrandt wrote:
an additional IF is needed in the spreadsheet. (I think this will be the
last IF needed request)
Phew!
If A1 is empty then B1 should be empty
If A1 has any number in it, that number in A1 is reduced by 3. If there
is 0
wrote:
Walter Hildebrandt wrote:
Great, the =IF(ISNUMBER(A1);A1-3;)
The following is a summary of what worked;
number one =IF(A1=0;��;A1) if A1 is empty get empty. If A1 has a 0 get an
empty cell. If there is a number that is not 0 get that number.
Number two =IF(ISBLANK(A1);��;A1
conditions. The goal is a feature that gives how much greater or how much
less A1 is compared to B1 (for example there are 2 cases (2 conditions)
where the answer is 0)
On Mon, Mar 9, 2009 at 4:38 PM, JOE Conner joeconner2...@gmail.com wrote:
Walter Hildebrandt wrote:
The =ABS(B1) + ABS(C1
- Original Message - From: Walter Hildebrandt wh9...@gmail.com
To: users@openoffice.org
Sent: Monday, March 09, 2009 10:13 PM
Subject: Re: [users] an empty cell in Calc
The =ABS(B1) + ABS(C1) has to work in all of the four conditions. it
only worked when B1 was 10% and C1 was -10%. D1 had
I am surprised how simple it is Thank you.
On Mon, Mar 9, 2009 at 6:45 PM, JOE Conner joeconner2...@gmail.com wrote:
Walter Hildebrandt wrote:
When 10 is in both A1 and B1 the ABS answer in C1 is 20
When -10 is in both A1 and B1 the ABS answer in C1 is 20
When -10 is in both A1 and B1
, Walter Hildebrandt wrote:
Using 3.1 with WindowsXP
As I mentioned before, I can speak only for 3.0.1. (Do you know that 3.1
will be different?)
If cell A1 is empty and =IF(A1;) is in B1, B1 will have the word FALSE.
What can be entered in B1 to get an empty B1 cell?
Well, the simplest
=A1 does not work because B1 will not be empty when A1 has a 0 in it.
On Sun, Mar 8, 2009 at 10:01 AM, Michael Adams mbad...@paradise.net.nzwrote:
On Sun, 08 Mar 2009 09:51:22 -0600
Came this utterance formulated by Walter Hildebrandt to my mailbox:
Sorry for the confusion. i will try
Wow it works. Thank you.
On Sun, Mar 8, 2009 at 10:13 AM, Brian Barker b.m.bar...@btinternet.comwrote:
At 09:51 08/03/2009 -0600, Walter Hildebrandt wrote:
Sorry for the confusion. i will try again.
If A1 is empty or has an 0 in it, I want B1 to be empty. At the same time
if A1 has any
:
At 18:41 08/03/2009 +, Harold Fuchs wrote:
On Sun, 08 Mar 2009 09:51:22 -0600
Came this utterance formulated by Walter Hildebrandt to my mailbox:
Sorry for the confusion. i will try again.
If A1 is empty or has an 0 in it, I want B1 to be empty. At the same
time if A1 has any number
Both of the suggestions works. Thank you.
On Sun, Mar 8, 2009 at 2:37 PM, Brian Barker b.m.bar...@btinternet.comwrote:
At 14:24 08/03/2009 -0600, Walter Hildebrandt wrote:
The spreadsheet is both large and complicated.
I don't think that's relevant!
I have a new questions
If A1
. If
there is a 3 in A1 then B1 would be 0.
On Sun, Mar 8, 2009 at 3:05 PM, Walter Hildebrandt wh9...@gmail.com wrote:
Both of the suggestions works. Thank you.
On Sun, Mar 8, 2009 at 2:37 PM, Brian Barker b.m.bar...@btinternet.comwrote:
At 14:24 08/03/2009 -0600, Walter Hildebrandt wrote
I am using 3.1 with WindowsXP
In Calc, Cell A1 is either empty or has a 0 in it.
Cell B1 has either =A1+20 in it.
When cell A1 is either empty or has a 0 in it, I want cell B1 to be empty or
in some way indicate that A1 is either empty or has a 0 in it.
If any number, except 0, is in cell A1 I
Using 3.1 with WindowsXP
If cell A1 is empty and =IF(A1;) is in B1, B1 will have the word FALSE.
What can be entered in B1 to get an empty B1 cell?
It worked. Thank you
On Sat, Mar 7, 2009 at 4:25 PM, Gene Young n2...@cfl.rr.com wrote:
Walter Hildebrandt wrote:
I am using 3.1 with WindowsXP
In Calc, Cell A1 is either empty or has a 0 in it.
Cell B1 has either =A1+20 in it.
When cell A1 is either empty or has a 0 in it, I want cell
Detwiler rlsha...@aol.com wrote:
Walter Hildebrandt wrote:
Using 3.1 with WindowsXP
If cell A1 is empty and =IF(A1;) is in B1, B1 will have the word FALSE.
What can be entered in B1 to get an empty B1 cell?
You don't say what you want in B1 if A1 is not empty.
If you want B1 to be equal
On a WindowsXP computer I updated to 3.0. Before updating my text
documents appeared properly on the screen. Now when I open a text
documents the page is partly out of view. I have to use the scrolling
at the bottom of the screen to move the page over to the left so that
the page is center
Using a 3.0 spreadsheet, is it possible to put a limit into a formula:
If $400 was in cell A1 and $416.67 is in call B1 and the formula in C1
was =A1-B1, the results in C1 would be -$16.67. Can the formula be
modified so that any time cell C1 produced a negative number, the entry
in C1 would
1 - 100 of 167 matches
Mail list logo