I use Calc to run a monthly (non-financial) spreadsheet for a small charity
I'm secretary to - a page per month, client cases on the vertical, various
circumstantial details across the columns, SUM at the bottom of each column,
the first of them a simple 'tally' column ( '1' entered for each
Daniel Devor wrote
> The LO instructions refer to "insert-file" but I cannot find any such
> in my copy of LO. Please advise how to run this function since my need
> is to do just that--insert or add a file to another. LO 5.3.03
Depending on your needs, in addition to the Insert -> Document
Perfect, thanks Miguel!
On 7/19/2014 10:04 AM, m.a.riosv miguelange...@libreoffice.org wrote:
For weeks they have been always in LibreOffice:
WEEKNUM( ) returns ISO 8601 week numbers.
WEEKNUM_ADD( ) returns week number as excel.
For days:
=DAYS(TODAY();DATE(YEAR(TODAY());1;1)-1)
I
For weeks they have been always in LibreOffice:
WEEKNUM( ) returns ISO 8601 week numbers.
WEEKNUM_ADD( ) returns week number as excel.
For days:
=DAYS(TODAY();DATE(YEAR(TODAY());1;1)-1)
I think the best way to find calc functions it's through function wizard:
Bravo! This was just the solution/explanation I needed!
joshsimpson josh.simpson at gmail.com writes:
So after some experimentation I've hit upon an easy fix for importing CSV
files with numbers ... changing the text delimiter to ' and selecting
Quoted field as text and Detect special
Hi :)
Uploading files to Nabble is usually easier. Either click on the links in
this email, or navigate from
LibreOffice.org
(errr, or google-it using LibreOffice Nabble (or something) for your
search)
Just above the space to entire your Message is a row of buttons including
one called
Hi,
From user point of view, I don't know but source code seems to be here:
http://opengrok.libreoffice.org/xref/core/scaddins/source/analysis/analysishelper.cxx#2506
I don't know much about generating help part but I found this:
IF(Test,OK,) shows OK if Test is True and nothing (the cell is blank) if
False
Hope this helps ;)
--
View this message in context:
http://nabble.documentfoundation.org/IF-Function-tp4062008p4062015.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
DOH!
Thanks all.
I gave you a wonderful chance to point out the bleeding obvious.
I tried putting the quote marks around the text and got an error result.
That was late last night so I must have done something wrong.
Tink.
--
View this message in context:
:)
From: Tinkerer j_taylo...@btinternet.com
To: users@global.libreoffice.org
Sent: Tuesday, 18 June 2013, 11:22
Subject: [libreoffice-users] Re: =IF Function
DOH!
Thanks all.
I gave you a wonderful chance to point out the bleeding obvious.
I tried putting the quote
Hi Michael,
I don't know why happen that, that it didn't work once, or twice some few
days back, but now it works.
Thank you for help and support!
-
Best Regards from
Pál
--
View this message in context:
I could not get your prompts to work, but they gave me ideas.
The final formula was:
=IFERROR(C30*100/B30,)
This also covered other errors where only one number was present, so no
calculation was possible.
Many thanks, Tink.
--
View this message in context:
Thank you Brian
I'd forgotten that there is a material difference between Empty cells and
Blank cells, even though I noticed that the result sometimes varied.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/IF-Function-tp4043493p4043610.html
Sent from the Users
Am 09.10.2012 12:24, Tom Davies wrote:
Hi :)
Is there not some way to identify how far along the letter is through one of
the count functions? If so then a +1 should give the required value?
In the interests of release early and release often it might be faster for
you to 'just' do a
Am 17.04.2012 19:35, Mike Phelan wrote:
I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once a number appears in B4:G11 4 times, it
changes color to Red...got that part.
Then I want to manually enter
Den 18 april 2012 09:47 skrev Andreas Säger ville...@t-online.de:
Am 17.04.2012 19:35, Mike Phelan wrote:
I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once a number appears in B4:G11 4 times,
it
Am 18.04.2012 17:56, Johnny Rosenberg wrote:
Den 18 april 2012 09:47 skrev Andreas Sägerville...@t-online.de:
Am 17.04.2012 19:35, Mike Phelan wrote:
I am trying to automatically remove a number from a range of cells, if it
appears in a different range.
I am creating a spreadsheet where once
Hi :)
Different devices or programs might decide to use different ways of defining
what a column contains and might also vary as to whether it treats a
particular column as a number or as text.
Typically i would open a Csv file with a text-editor such as Scite, Gedit or
even Notepad (if that's
Get the Extension CT2N, which is convert text2 Numbers.
You only jump through one loop then.
Tink.
--
View this message in context:
http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3481046.html
Sent from the Users mailing list archive at
So after some experimentation I've hit upon an easy fix for importing CSV
files with numbers ... changing the text delimiter to ' and selecting
Quoted field as text and Detect special numbers does the trick. Of
course you have to save the file before you can SUM or do anything else.
The nice
I'm having this same problem and I must admit, this is a deal breaker for
LibreCalc for me and possibly for Linux since I can't use VMWare on kernel
3.0.o.1.
Going to try Google Docs but I am stunned that LibreOffice makes you jump
through so many hoops to using the SUM function on a column of
Hi.
I think it is the way it is used.
Say in your formula you have something worth 2000 in 5 years at 8%, you
would write;
NPV = 2000/(1+0.08)^5 =1361.17
In LO the function is for a series of payments, you have 1 payment at 5
years, you would write;
=NPV(0.08;0;0;0;0;2000) = 1361.17
steve
On
Hello again,
After running a few different examples, I have confirmed with some
classmates that in this instance it is a publishing error in my
textbook (what I was comparing against initially) and in the case of
my own calculations, my t value was off by one. Sorry for any
confusion!
Thanks for
If you don't want any errors even in the 10th digit, I think it's probably a
good idea to use ROUNDUP and ROUNDDOWN instead of adding or subtracting
0.005 for the final result. So, my final function for a Bankers Round that
I'm using is:
colinkeenan wrote:
plino wrote:
I had never heard of bankers rounding before. Interesting concept.
There is no such function in OOo/LO, Excel or Gnumeric...
But you can easily create a function
=IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1))
(Adjust if your
plino wrote:
I had never heard of bankers rounding before. Interesting concept.
There is no such function in OOo/LO, Excel or Gnumeric...
But you can easily create a function
=IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1))
(Adjust if your separator is a comma
What I meant was: if the original numbers have a mixed number of decimal
cases you can't apply my solution because of the base 2 calculations.
But I assume that in a table you don't have values with 3 decimal cases
mixed with one decimal case?
Therefore you could go from 4 decimal cases to 1
On 19/02/11 00:38, Robert Prins wrote:
On Sat, Feb 19, 2011 at 00:24, plinopedl...@gmail.com wrote:
I had never heard of bankers rounding before. Interesting concept.
There is no such function in OOo/LO, Excel or Gnumeric...
But you can easily create a function
Hi all,
Andreas Säger schrieb:
Am 19.02.2011 00:50, Robert Prins wrote:
Why is there no standard function to do bankers rounding (aka
round-to-even)?
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
Indeed, MROUND is not a standard function. It is part
I had never heard of bankers rounding before. Interesting concept.
There is no such function in OOo/LO, Excel or Gnumeric...
But you can easily create a function
=IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1))
(Adjust if your separator is a comma instead of a semi-colon)
On Sat, Feb 19, 2011 at 00:24, plino pedl...@gmail.com wrote:
I had never heard of bankers rounding before. Interesting concept.
There is no such function in OOo/LO, Excel or Gnumeric...
But you can easily create a function
=IF(A1-INT(A1)=0.5;IF(ISEVEN(INT(A1));A1-0.5;A1+0.5);ROUND(A1))
Am 19.02.2011 00:50, Robert Prins wrote:
Why is there no standard function to do bankers rounding (aka round-to-even)?
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
Indeed, MROUND is not a standard function. It is part of the (always
installed)
Am 19.02.2011 02:25, Andreas Säger wrote:
Am 19.02.2011 00:50, Robert Prins wrote:
Why is there no standard function to do bankers rounding (aka
round-to-even)?
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_MROUND_function
Indeed, MROUND is not a standard function.
On Sat, Feb 19, 2011 at 01:05, plino pedl...@gmail.com wrote:
It's only slightly more complicated :)
=IF(VALUE(RIGHT(A9))=5;IF(ISEVEN(VALUE(LEFT(RIGHT(A9;2;A9-0.005;A9+0.005);ROUND(A9;2))
Check if the last digit is 5. If it is add 0.005 if the previous digit is
odd or subtract if it is
plino pedlino at gmail.com writes:
Bill, do the cells in the range contain only natural numbers?
I suspect that you are having a problem with the decimal separator.
Your cells are probably identified as text because of that (are the values
aligned to the left?)
Paste this in cell
Bill, do the cells in the range contain only natural numbers?
I suspect that you are having a problem with the decimal separator.
Your cells are probably identified as text because of that (are the values
aligned to the left?)
Paste this in cell D2 to check
=VALUE(C2)
--
View this message
Actually it depends on your Language Settings.
And LibreOffice inherited the problems from OpenOffice...
E.g. for Portuguese (European) the decimal separator is a comma(,) but if I
prefer to use a point (because most international publications are formatted
according to US notation) when I
Am 03.11.2010 23:12, bill woodruff wrote:
mouse. And when I manually insert the range (i.e., =SUM(C2,C46))
it returns a
result of 0 (zero).
You try to sum numeric text (a sequence of digits).
--
E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe
List archives are
Mark mhullrich at gmail.com writes:
A sum range is =SUM(C2:C46) - could that be (part of) it?
Mark
Hello, Mark:
Thank you for your prompt reply. I apologize, but I mis-punctuated
my original message. The formula, as you correctly observe, is =SUM(C2:C46)
--and that's pasted
39 matches
Mail list logo