Re: [libreoffice-users] Calc Function Wizard - IF Result differences

[Ady]

> Hi,
> 
> Entering a formula into the Function Wizard in Calc shows  up two 
> different answers in the 'Result' and 'Function Result' answer box.
> 
> If the editing cursor is placed in a certain section of the formula, 
> only the 'Function Result' answer box holds the correct answer i.e. 
> 751.52004. Pressing 'OK' puts the 'Result' answer box value in the 
> calculated cell, which unfortunately is the wrong answer i.e. 751.25.
> 
> I have looked at the help file to see if there was a difference between 
> the Result answer boxes but found none.
> 
> The initial formula is:
> =IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20))
> 
> In addition I have tried changing the formula without success to try and 
> reduce the multiple nested IF functions:
> 
> i.e.:
> =sum((IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20)),0)
> 
> The SUMIF function was also tried but my brain just gave up.
> 
> I cannot see how the VLOOKUP function will help either as I am not 
> looking up values from cells, I am calculating a single value in H4 
> based in a variable input in G4.
> 
> Have a peak at the uploaded spreadsheet on Nabble:
> 
> http://nabble.documentfoundation.org/file/n4077843/Electricity.ods
> 
> You will see that provided you enter a value for G4 below 600 the 
> correct answer is shown i.e. for 600 in G4 H4=750. The moment G4 exceeds 
> 600, even by 1, there is a problem.
> 
> There must be an answer and or  my formula syntax is wrong unbeknown to me.
> 
> Help would be very much appreciated
> 
> Sincerely
> Hylton
> -- 
 
The spreadsheet structure you are using is not so adequate for this 
calculation.

I have a suggestion for your formula in H4. But, before I post it, 
you should know that there are better possibilities, and that my 
suggestion doesn't solve all your problems in that spreadsheet. 
Additionally, the formula I am suggesting might not be optimized, and 
it is certainly not the only solution.

Anyway, in your posted spreadsheet, Electricity.ods -> Data2 sheet -> 
Cell H4, I suggest the following formula as one possibility:

 
=(0http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] RTF

[Mark LaPierre]

On 10/19/2013 04:43 AM, Patrick wrote:
> Hello,
> 
> I've received this .rtf file (attachment) with a little picture on the left 
> side that i can't see with Libre Office. I'm using Ubuntu because I hate 
> Microsoft and all their products :) ... So, in conclusion, my friend (on 
> Microsoft Office Word) opened this file and the picture was here. I'm asking 
> now, could this problem be resolved in the future Libre Office release?
> 
> Best regads,
> 
> Patrick Demarki dipl.ing.
> 

Hey Patrick,

RTF stands for Rich Text File.  Many email tools can handle RTF files.
Try opening the file with whatever mail tool you have available to see
what happens.

-- 
_
   °v°
  /(_)\
   ^ ^  Mark LaPierre
Registered Linux user No #267004
https://linuxcounter.net/


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] RTF

[Patrick]

Hello,

I've received this .rtf file (attachment) with a little picture on the left 
side that i can't see with Libre Office. I'm using Ubuntu because I hate 
Microsoft and all their products :) ... So, in conclusion, my friend (on 
Microsoft Office Word) opened this file and the picture was here. I'm asking 
now, could this problem be resolved in the future Libre Office release?

Best regads,

Patrick Demarki dipl.ing.
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

[Paul]

As I noticed you're practically around the corner from me, I got
interested, and had a look at your spreadsheet :)

[tl;dr: I got solutions, but need some help uploading the file. Also,
it may be that you could work it out in a *much* simpler way, using
what you already have, but a) something is broken in your other
formulas, and b) that's if they are supposed to do what I think they
are.]

I can see what you are trying to do, but it took some figuring out. I'm
not convinced you have everything laid out correctly in that file. For
example, your "Max Units" column has a complicated calculation that
doesn't actually just figure out the difference between the two
"brackets" (as I called the groups). For example, between the 0->150
bracket and the 150->300 bracket, the difference should be 300 - 150,
but instead you calculate something using an IF. I don't know why, but I
wasn't really focusing on that, it just seems odd (and possibly
incorrect) to me.

As for your problem at hand. The formula you are using is way too
complex. I would not use something like that, I would either split it
up into more columns, or write a user function for it. I actually
played a little with it to figure out how it worked, and ended up
amending your spreadsheet to include both solutions.

As I understand the problem, you have a value that needs splitting up
into the different price brackets, and then a per bracket price is
calculated, and you need the total of the per bracket prices. The split
is by amount, that is to say the first bracket is the first 150 units of
the value, the second bracket is the next 200 units, and so on. Each
bracket has a unit price, and once you figure out how many units of the
value falls into each bracket, you can work out the price for those
units, and then total it to get a final price for the value. Sorry if
that is a convoluted explanation, but it's the best way I could think
of to describe it.

It is not clear to me how VLOOKUP could be used for this, as the
problem as I understand it isn't one of matching your cell to a given
list of criteria and inserting a corresponding value.

I also can't explain my solutions here, as I haven't simply "fixed"
your formula. I have saved your file with both solutions. I would
gladly upload it for you to look at, but I'm not sure how to upload
files. I know I can't do it via email, as attachments apparently get
stripped, and I can't see how to do it from nabble, unless you only get
that option when logged in. If so, what are my login details? As I'm
subscribed to the list, I would assume that means I have a login for
nabble, or is it a separate thing? All I know about nabble is that it
has to do with the mailing lists...

The user function solution is elegant, and simply replaces your formula
with a user function call, and the user function is written in LO
Basic. Very straight forward. I have only used your original columns
as input to that function. I have assumed only four price brackets, so
if any more are added, the function calls and the function itself will
need some amending. The other solution involves adding a whole bunch of
columns to your spreadsheet to calculate intermediate steps. This does
mean no additional coding skills required, and the benefit is each step
is then simple and clear, your solution can be easily checked, and you
have the break-downs by price bracket. Again four brackets are assumed,
but should more be made, you can simply add more columns, which you
would have to do anyway. The downside is more columns, but as the ones
I added all contain formulas, they can be hidden once the formulas are
copied to all relevant rows.

Note that I messed around a bit with the spreadsheet, possibly removing
some formulas in the process, so don't simply use the spreadsheet as I
give it to you. Read and understand my solution, then implement it in
your spreadsheet. The user function code can probably be copied
straight out, though.

So yes, I have a solution for you, I just need some assistance
uploading it. The moral of the story, though, is that you shouldn't try
to make such convoluted formulas. Use columns for intermediate steps,
and keep each step simple. Or use user defined functions if you must
have it in one step and have some coding skills. If there is a simpler,
built-in function that can do this, or that can simplify your formula to
manageable proportions, I don't know what it is.

Paul

P.S. Looking at your "Max Units" column now, it seems like this may be
one of the values I am calculating, so my solutions could have been a
little simpler. However, this is not clear to me, as those cells
calculate their value based on values in their row, and not in the row
of the "Last Day Closing Balance" column. I assume the two sets of rows
will contain the same data, but I don't know that for sure. If so, why
don't you simply total up the "Rand Value" columns in the second set of
rows?

And looking at this shows even more problems with the sprea

[libreoffice-users] Re: Formatting Toolbar question, 4.1.2.3

[Pedro]

Hi snowshed


snowshed wrote
> Giving LO another chance, and experimenting with toolbar placement on 
> the screen, basically moving them from the default horizontal position 
> at the top, to a vertical position the side.

Since you are running a 4.1 version why don't you try the Sidebar?

Go to Tools > Options > LibreOffice, Advanced and then on "Optional
(unstable) options" check the option "Enable experimental sidebar (on
restart)"

Then you can simply disable the Formatting Toolbar because it's redundant ;)


snowshed wrote
> Anyone know the reason(s) for replacing the actual field boxes that give 
> you the name of the style, font, and font size with nothing but an icon 
> when the toolbar is vertical?  At least they could have a fly out box 
> that tells you what you're currently using rather than opening the 
> complete font dialogue.

There is no reason. It's a bug :) Maybe you can report it at
https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice
?

Best regards,
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/Formatting-Toolbar-question-4-1-2-3-tp4078774p4078824.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc IF problem

[Paul]

On Sat, 19 Oct 2013 15:46:56 +0100
Brian Barker  wrote:

> o Remember that multiplication precedes addition and subtraction in 
> evaluation, so many of your parenthesis pairs are unnecessary.  You 
> may think they clarify things, but in my experience they obfuscate 
> the meaning of a formula and mask errors.
While I agree with Brian's other points, I just wanted to comment that
normally, I find it much better to include parentheses around sums,
explicitly stating the order, rather than relying on (sometimes
differing) operator precedence rules. This also helps to group things,
and in my opinion usually makes things more clear, rather than
obfuscating anything. However, in this extreme example, I doubt it would
make much difference either way.

Paul

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] 10 Oldest Bugs Needing Triaged

[Joel Madero]

Hi All,

These 10 bugs are the oldest bugs that are lingering for triaging, 
please take a moment and see if you have the skills/setup required to 
triage them. Please triage directly on the bug (not via email), mark as 
NEW and leave a comment if you can confirm, if you cannot confirm 
(behavior is correct) mark as RESOLVED-WORKSFORME and leave a comment, 
if the instructions are unclear on the bug report, ask for clearer 
instructions and mark as NEEDINFO. In commenting please make sure to say 
your setup (computer OS, LibreOffice version).


All the Best,
Joel

46028  	LibreOff 
Writer 	libreoffice-b...@lists.free... 	UNCO 	--- 	[RFE, FORMATTING] 
Permit associating an image/symbol/text label to a paragraph style 
 	2012-05-19 	

Not Assigned
All 
4   2012-02-14  All medium  

	nicolas.mail...@laposte.net 	Nicolas Mailhot 	enh 	[RFE, FORMATTING] 
Permit associating an image/symbol/text... 
 	

unspecified 0   
50282  	LibreOff 
Libreoff 	libreoffice-b...@lists.free... 	UNCO 	--- 	The template 
manager should allow to copy several styles at once 
 	2012-05-24 	

Not Assigned
Oth 
2   2012-05-23  All medium  

	oc-spa...@laposte.net 	oc-spam65@laposte... 	enh 	The template manager 
should allow to copy several styles ... 
 	

3.5.3 release   0   
46582  	LibreOff 
Writer 	libreoffice-b...@lists.free... 	UNCO 	--- 	FORMATTING: 
Description of Styles -> Border -> "Merge with next paragraph" could use 
clarification  
2012-05-24 	

Not Assigned
Oth 
7   2012-02-24  All medium  

	j...@grossart.net 	Jon Grossart 	enh 	FORMATTING: Description of Styles 
-> Border -> "Merge wit... 
 	

3.5.0 release   0   BSA
47892  	LibreOff 
Libreoff 	libreoffice-b...@lists.free... 	UNCO 	--- 	Option cli 
-convert-to should also have the option to specify filterOption 
 	2012-06-19 	

Not Assigned
Oth 
2   2012-03-26  All medium  

	bulle...@gmail.com 	marco 	enh 	Option cli -convert-to should also have 
the option to spe...  	

unspecified 0   
51303  	LibreOff 
Writer 	libreoffice-b...@lists.free... 	UNCO 	--- 	MAILMERGE: Writer 
should not print picture on empty label 
 	2012-06-21 	

Not Assigned
Oth 
1   2012-06-21  All medium  

	legluondu...@free.fr 	Le Gluon du Net 	nor 	MAILMERGE: Writer should 
not print picture on empty label 
 	

3.5.3 release   0   BSA
51132  	LibreOff 
Writer 	libreoffice-b...@lists.free... 	UNCO 	--- 	After one success, 
PRINTING of #10 ENVELOPES failed to print properly, apparently due to 
incorrect formatting of the envelope document by the 'Insert Envelope' 
wizard.  	2012-06-21 	

Not Assigned
x86 
2   2012-06-15  Windmedium  

	joyce...@gmail.com 	John Joyce 	nor 	After one success, PRINTING of #10 
ENVELOPES failed to pr... 
 	

3.5.4 release   0   
47890  	LibreOff 
Writer 	libreoffice-b...@lists.free... 	UNCO 	--- 	PRINTING: Mail Merge 
window always resizes to standard size 
 	2012-06-25 	

Not Assigned
Oth 
3   2012-03-26  All medium  

	hein2h...@googlemail.com 	Ray D 	nor 	PRINTING: Mail Merge window 
always resizes to standard size 
 	

3.4.5 release   0   BSA
51851  	LibreOff 
Installa 	libreoffice-b...@lists.free... 	UNCO 	--- 	Improvement - add 
registry actually version and MSI product number 
 	2012-07-07 	

Not Assigned
x86 
1   2012-07-07  Windmedium  

	joao.corm...@sisejuferj.org.br 	João Mac-Cormick 

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

[Brian Barker]

At 14:36 19/10/2013 +0200, Hylton Conacher wrote:
Entering a formula into the Function Wizard in Calc shows up two 
different answers in the 'Result' and 'Function Result' answer box.


Certainly: there would otherwise be no point in having two 
boxes.  Suppose you use the Function Wizard to construct 
=3+SQRT(4).  The function result is 2 but the formula result is 5.


In addition I have tried changing the formula without success to try 
and reduce the multiple nested IF functions:

i.e.:
=sum((IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20)),0)

I cannot see how the VLOOKUP function will help either as I am not 
looking up values from cells, I am calculating a single value in H4 
based in a variable input in G4.


But your formula refers to the values in row 20, which are thus the 
values you need to look up.  Your IF conditions are your current way 
of selecting the appropriate values from that row.



Have a peak at the uploaded spreadsheet on Nabble:


Will do - but I'll need more than a peek!

You will see that provided you enter a value for G4 below 600 the 
correct answer is shown i.e. for 600 in G4 H4=750.


I think this may be more by luck that judgment, as the prices for 
your first three ranges are identical - which doesn't test your 
formula effectively.



There must be an answer and or my formula syntax is wrong unbeknown to me.


Oh, the formula is certainly wrong.  There will be a right one ...

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc IF problem

[Brian Barker]

At 19:11 10/10/2013 +0200, Hylton Conacher wrote:

The below formula calculates H4
=IF(0

Just to add to what I wrote before, if you want to test a condition 
that you would write mathematically as AAND(A

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

[Jean-Francois Nifenecker]

Hi,

Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit :
> 
> The initial formula is:
> =IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20))

this is waaay too convoluted to be easily checked.

> 
> There must be an answer and or  my formula syntax is wrong unbeknown to me.
> 

Sure, there is. As your request looks very much like your previous one,
I highly encourage you to read Brian's answer to that one: it's filled
will good advice. IOW, when you can write your problem down using common
speech (not some spreadsheet language), I'm sure you'll turn having
found the solution by yourself.

-> I share Brian's idea about using VLOOKUP() through a 3 lines set of data.

HTH,
-- 
Jean-Francois Nifenecker, Bordeaux

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc Function Wizard - IF Result differences

[Jay Lozier]

Hylton,

If you can breakup the formula into smaller units you might find the
problem. 

Often when I have had a similar problem I found the my problem
was I reversed test in an IF clause.

On Sat, 2013-10-19 at 14:36 +0200, Hylton Conacher (ZR1HPC) wrote: 
> Hi,
> 
> Entering a formula into the Function Wizard in Calc shows  up two 
> different answers in the 'Result' and 'Function Result' answer box.
> 
> If the editing cursor is placed in a certain section of the formula, 
> only the 'Function Result' answer box holds the correct answer i.e. 
> 751.52004. Pressing 'OK' puts the 'Result' answer box value in the 
> calculated cell, which unfortunately is the wrong answer i.e. 751.25.
> 
> I have looked at the help file to see if there was a difference between 
> the Result answer boxes but found none.
> 
> The initial formula is:
> =IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20))
> 
> In addition I have tried changing the formula without success to try and 
> reduce the multiple nested IF functions:
> 
> i.e.:
> =sum((IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20)),0)
> 
> The SUMIF function was also tried but my brain just gave up.
> 
> I cannot see how the VLOOKUP function will help either as I am not 
> looking up values from cells, I am calculating a single value in H4 
> based in a variable input in G4.
> 
> Have a peak at the uploaded spreadsheet on Nabble:
> 
> http://nabble.documentfoundation.org/file/n4077843/Electricity.ods
> 
> You will see that provided you enter a value for G4 below 600 the 
> correct answer is shown i.e. for 600 in G4 H4=750. The moment G4 exceeds 
> 600, even by 1, there is a problem.
> 
> There must be an answer and or  my formula syntax is wrong unbeknown to me.
> 
> Help would be very much appreciated
> 
> Sincerely
> Hylton
> -- 
> 
> Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
> http://www.fishhoeklionsclub.org.za being part of the worlds
> largest non profit NGO
> 
> 
> 

-- 
Jay Lozier
jsloz...@gmail.com


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calc IF problem

[Brian Barker]

At 19:11 10/10/2013 +0200, Hylton Conacher wrote:

I have a spreadsheet with four pricing ranges for a certain number of units.

G4 = 601
H4 = calculated by below formula = 751.25 but should be 751.52
.
F20 = 1.25
G20 = 150 i.e. 0->150 units
h20 = F*G

I20 = 1.25
J20 = 200 i.e. 150.0001 -> 350 units
K20 = I*J

L20 = 1.25
M20 = 250 i.e. 350.0001 -> 600 units
N20 = L*M

O20 = 1.52
P20 >= 600 i.e. 600.0001 -> infinity units
Q20 = O*P

The below formula calculates H4
=IF(0=$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20))

Is there a simpler way to achieve the right answer i.e. 751.52 as I 
have checked all the cell values and they all read as indicated here.


Where am I making a mistake?


Sorry if this appears critical, but there are a number of things to say here.

o To get the best help from others, you really do need to explain 
your problem in detail - and that means words, not formulae or 
values.  Once you have defined your problem, it is very likely 
someone can help you.  Indeed, explaining your problem concisely and 
completely may well help you to see how to solve it yourself!


o You have laid your values out as a row (in row 20) - as if it's a 
vector, a twelve by one array.  But surely it is a four by three 
array?  Setting this out as four rows of three columns would help you 
see what the likely solution was.  And you have not used those 
products (H20, K20, etc.) in your formula: instead, you have 
effectively recalculated them all, so they are just distracting.


o I always hope it's obvious (but it's clearly not) that you cannot 
define what you are trying to calculate by quoting a formula that you 
know doesn't work.  This must indicate what you *don't* 
want!  Please, please omit all the detail and say what you do 
want.  (Forcing yourself to do this is a good first step in solving 
any problem.)


o Any formula as complicated and repetitive as this cannot be the 
right way to do things.  Apart from anything else, you might not 
notice any slip you might have made in the middle of the formula, and 
it would be quite easy to miss it during testing.  Anything 
repetitive should be reduced to a simpler formula that nevertheless 
deals with all situations.


o You have apparent logical expressions such as 0Ayou find any suggestion that it makes sense in spreadsheet 
lingo?!  Since it's undefined, I'm having to guess what this will 
mean to Calc.  First, 0or FALSE.  Now the rest of the expression reduces to TRUE<=$G$20 or 
FALSE<=$G$20 - which make no sense, of course.  In practice, it seems 
that the logical values are interpreted as numbers - with FALSE being 
zero and TRUE being one - and this numerical value is then compared 
with $G$20.  But these values are 150, 200, and so on, which will 
always be greater than either zero or one, so all the conditions will 
evaluate to TRUE!


o Your last IF function has a argument for truth but not one for 
falsehood, so the logical value FALSE will be substituted.  You have 
given no alternative because your final condition is bound to be true 
if the previous ones have all been false, so you don't need 
it.  Remove that IF!


o Remember that multiplication precedes addition and subtraction in 
evaluation, so many of your parenthesis pairs are unnecessary.  You 
may think they clarify things, but in my experience they obfuscate 
the meaning of a formula and mask errors.


There is a lot here that anyone helping is still having to guess, but 
the problem is almost certainly best solved using VLOOKUP().  I 
haven't had time to look at it yet ...


I trust this helps (so far).

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc Function Wizard - IF Result differences

[Hylton Conacher (ZR1HPC)]

Hi,

Entering a formula into the Function Wizard in Calc shows  up two 
different answers in the 'Result' and 'Function Result' answer box.


If the editing cursor is placed in a certain section of the formula, 
only the 'Function Result' answer box holds the correct answer i.e. 
751.52004. Pressing 'OK' puts the 'Result' answer box value in the 
calculated cell, which unfortunately is the wrong answer i.e. 751.25.


I have looked at the help file to see if there was a difference between 
the Result answer boxes but found none.


The initial formula is:
=IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20))

In addition I have tried changing the formula without success to try and 
reduce the multiple nested IF functions:


i.e.:
=sum((IF(0$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20)),0)

The SUMIF function was also tried but my brain just gave up.

I cannot see how the VLOOKUP function will help either as I am not 
looking up values from cells, I am calculating a single value in H4 
based in a variable input in G4.


Have a peak at the uploaded spreadsheet on Nabble:

http://nabble.documentfoundation.org/file/n4077843/Electricity.ods

You will see that provided you enter a value for G4 below 600 the 
correct answer is shown i.e. for 600 in G4 H4=750. The moment G4 exceeds 
600, even by 1, there is a problem.


There must be an answer and or  my formula syntax is wrong unbeknown to me.

Help would be very much appreciated

Sincerely
Hylton
--

Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://www.fishhoeklionsclub.org.za being part of the worlds
largest non profit NGO



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Formatting Toolbar question, 4.1.2.3

[Ken Springer]

Giving LO another chance, and experimenting with toolbar placement on 
the screen, basically moving them from the default horizontal position 
at the top, to a vertical position the side.


Anyone know the reason(s) for replacing the actual field boxes that give 
you the name of the style, font, and font size with nothing but an icon 
when the toolbar is vertical?  At least they could have a fly out box 
that tells you what you're currently using rather than opening the 
complete font dialogue.



--
Ken

Mac OS X 10.8.5
Firefox 24.0
Thunderbird 17.0.8
LibreOffice 4.1.1.2


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted