This message never seemed to get thru :(
Original Message
Subject: Re: [libreoffice-users] Calc sliding scale formulae?
Date: Fri, 18 Jan 2013 14:00:19 +0200
From: Hylton Conacher (ZR1HPC) hyl...@conacher.co.za
Reply-To: LibreOffice Users users@global.libreoffice.org
To: users
...@gmail.com
To: users@global.libreoffice.org
Sent: Friday, 18 January 2013, 15:34
Subject: Re: [libreoffice-users] Calc sliding scale formulae?
Perhaps the private suggestion was correct. Perhaps your understanding
of Algebra is not as good as it needs to be. After all this is an Algebra
It has been privately suggested to me that I want my work done for me,
however, whilst I have had theory from the list on how the formulae
should work, I have not had anyone indicating how I can get Calc to only
use a particular formula range until its result exceeds the amount
allowed for
Perhaps the private suggestion was correct. Perhaps your
understanding of Algebra is not as good as it needs to be. After all
this is an Algebra problem.
Now for some questions:
1. How much will 1 to 150 units cost? What is the formula to determine this?
2. How much will 151 to 599
.
Regards from
Tom :)
From: Dan Lewis elderdanle...@gmail.com
To: users@global.libreoffice.org
Sent: Friday, 18 January 2013, 15:34
Subject: Re: [libreoffice-users] Calc sliding scale formulae?
Perhaps the private suggestion was correct. Perhaps your
Jay,
Thank you. Your input is appreciated. My comments below.
On 10/01/13 19:36, Jay Lozier wrote:
On 01/10/2013 10:38 AM, Hylton Conacher (ZR1HPC) wrote:
Hi,
I am using Calc 3.4.5 on openSuSe Linux 11.2
I am working on a spreadsheet to cater for the monthly measurement of
household
Hi,
I am using Calc 3.4.5 on openSuSe Linux 11.2
I am working on a spreadsheet to cater for the monthly measurement of
household electricity consumption, new unit purchase and costing of used
units.
The electricity supplier gives me the first 150 units of electricity at
R1.29 per unit. The
On 01/10/2013 10:38 AM, Hylton Conacher (ZR1HPC) wrote:
Hi,
I am using Calc 3.4.5 on openSuSe Linux 11.2
I am working on a spreadsheet to cater for the monthly measurement of
household electricity consumption, new unit purchase and costing of
used units.
The electricity supplier gives me