[libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-19 Thread zr1hpc
Hi Steve, Your input provided the solution to the formula syntax and use. Had you looked, I am assuming you did not, at the Nabble document I had uploaded with the original question you would have seen the correct values for some of the 'Givens' you listed i.e. If you have G2 as your input,

Re: [libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-17 Thread Hylton Conacher (ZR1HPC)
Hi Tom, On 14/02/13 16:41, Tom wrote: Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Thanks , I was hoping so. snip I wonder if there is a really good Maths forum for getting

Re: [libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-17 Thread Steve Edmonds
On 2013-02-18 07:31, Hylton Conacher (ZR1HPC) wrote: Hi Tom, On 14/02/13 16:41, Tom wrote: Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Thanks , I was hoping so. snip I

[libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-14 Thread Tom
Hi :) Yes, of course you can ask different questions. I just thought it was exactly the same question again in which case my answer wouldn't have been so wrong. Also i really don't think we have a problem with trying to help people with their homework. Of course there are always 1 or 2 awkward

[libreoffice-users] Re: Calc scale formula conundrum/ logic confusion

2013-02-14 Thread GĂ©rard Fargeot
Hi, zr1hpc wrote Using Calc 3.4.5 on openSuse 11.2 I am trying to work out the currency value of the amount of electricity units I have left at the end of the month (G2). This same formula will be used for the other 11 months of the year with only the G2 reference changing to G3,