Hi Walter
have you any time used the function-buttom in calc. There you will find
some solutions to your questions.
Try to write your funktion like you formulate it in this dokument.
write in B1: *= if(A1="";A1;A1-3)*
sincerely
Franz
Walter Hildebrandt schrieb:
an additional IF is needed in the spreadsheet. (I think this will be the
last IF needed request)
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 in A1 then B1 would be -3. If there is a 4 in A1 then B1 would be 1. 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.com>wrote:
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 is empty then B1 should be empty
If A1 has a 0 then B1 should have 0 (a zero)
If A1 has any number except 0, then that number should be in B1
This can be solved by the *other* suggestion provided earlier:
=IF(ISBLANK(A1);"";A1)
An alternative could be:
=IF(ISNUMBER(A1);A1;"")
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
