On 20/10/13 01:15, Paul wrote:
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
On Mon, 21 Oct 2013 14:32:40 +0200
Hylton Conacher (ZR1HPC) hyl...@conacher.co.za wrote:
appreciated especially as he also indicates that using VLOOKUP would
not work, in this case. MIN and MAX are still under testing here :)
Brian indicated that VLOOKUP would work; I don't say different, I'm
Let me rather put it this way: I don't think using VLOOKUP solves the
underlying problem, which is that too much is being done in one
formula.
For any complicated formula, I feel the best solution is either a
custom written user function, or intermediate steps in columns. Hide
those columns, or
Another trick that occurred to me when viewing that spreadsheet was
this one: Some of the column headers contain values that are needed in
calculations. Say for instance you have a column header in cell A1 that
reads Max units 250. You can extract the value (250) with
=VALUE(RIGHT(A1,3))
Or, you
Jay,
On 19/10/13 19:23, Jay Lozier wrote:
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.
Thanks, I have checked all the IF tests and mathematically they
On 19/10/13 19:32, Jean-Francois Nifenecker wrote:
Hi,
Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit :
The initial formula is:
On 19/10/13 20:25, Brian Barker wrote:
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.
Hi Paul,
On 21/10/13 00:26, Paul wrote:
Ok, so I just used a file hosting service found via Google search.
Here's the file I modified with my two solutions:
http://www.filedropper.com/electricity_1
It didn't work the first time or two that I tried to download the file
to check, not sure why,
At 17:31 21/10/2013 +0200, Hylton Conacher wrote:
On 19/10/13 19:32, Jean-Francois Nifenecker wrote:
Le 19/10/2013 14:36, Hylton Conacher a écrit :
The initial formula is:
[...]
this is waaay too convoluted to be easily checked.
I would agree, but it should still work.
Any formula that
At 18:40 21/10/2013 +0200, Hylton Conacher wrote:
I like Brian's MIN/MAX idea too but the price might well need to
change on a month, it just depends on when the local authority
increases prices.
That idea is equally applicable to your current arrangement - with
the price band values
I still think the VLOOKUP function can help tremendously but it does, in
practice, need one or two more columns in the lookup table.
The table as it exists has the number of units in each range, rather
than the values at the breakpoints. These breakpoint values are vital,
as they are what
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.
At 14:36 19/10/2013 +0200, Hylton Conacher wrote:
The initial formula is:
Ok, so I just used a file hosting service found via Google search.
Here's the file I modified with my two solutions:
http://www.filedropper.com/electricity_1
It didn't work the first time or two that I tried to download the file
to check, not sure why, but it worked the third time, so maybe
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.
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
Hi,
Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit :
The initial formula is:
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
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
19 matches
Mail list logo