libreofficecalc formula

[Bob Elzer]

Spreadsheet's don't work like calculators, when you type something into a
cell that's what stays there.

Here is a free budget calculator spreadsheet
http://templates.libreoffice.org/template-center/personal-budget-template
On Sep 3, 2015 7:01 AM, "Michael Havens" <bmike1 at gmail.com> wrote:

> in the 'real' cell it doesn't disappear waiting for a new entry to
> calculate into budget remaining.
>
> On Thu, Sep 3, 2015 at 9:43 AM, Rusty Ramser <rusty_ramser at hotmail.com>
> wrote:
>
>> If I’m understanding you correctly, that’s exactly what the formula and
>> fill down steps will do for you.  You can change numbers in columns A and
>> B, and the formula in column C will re-calculate real-time with every
>> modification.
>>
>>
>>
>>
>>
>> ----- Original Message -----
>>
>> *From:* plug-discuss-bounces at lists.phxlinux.org [mailto:
>> plug-discuss-bounces at lists.phxlinux.org] *On Behalf Of *Michael Havens
>> *Sent:* Thursday, 3 September 2015 06:36
>> *To:* Main PLUG discussion list
>> *Subject:* Re: libreofficecalc formula
>>
>>
>>
>> Well, what I want is for it to keep a running balance so that I could
>> enter 4 into 'real' and after I hit the enter key the figure in 'real'
>> would disappear and the calculation would take place.
>>
>>
>>
>>
>>
>> ----- Original Message -----
>>
>> *From:* plug-discuss-bounces at lists.phxlinux.org [mailto:
>> plug-discuss-bounces at lists.phxlinux.org] *On Behalf Of *Rusty Ramser
>> *Sent:* Thursday, 3 September 2015 06:22
>> *To:* 'Main PLUG discussion list'
>> *Subject:* RE: libreofficecalc formula
>>
>>
>>
>> If your cells are set up like the following:
>>
>>
>>
>> A
>>
>> B
>>
>> C
>>
>> 1
>>
>> Budget
>>
>> Real
>>
>> Budget Remain
>>
>> 2
>>
>> 600
>>
>> 600
>>
>> 0
>>
>> 3
>>
>> 700
>>
>> 50
>>
>> 650
>>
>>
>>
>> Then in cell C2 you would put this formula:  =a2-b2
>>
>>
>>
>> Then, highlight/select cells C2 all the way down to C99 (or whatever your
>> last row entry is).  If you have data down to the 13th row, you should
>> have cells C2 to C13 highlighted.  Once you do, press Ctrl-D to “fill
>> down”.  The formula you entered into C2 (the topmost cell highlighted) will
>> be filled down to all the lower cells and you’ll have your calculation
>> working.
>>
>>
>> Cheers.
>>
>>
>>
>>
>>
>> ----- Original Message -----
>>
>> *From:* plug-discuss-bounces at lists.phxlinux.org [
>> mailto:plug-discuss-bounces at lists.phxlinux.org
>> <plug-discuss-bounces at lists.phxlinux.org>] *On Behalf Of *Michael Havens
>> *Sent:* Thursday, 3 September 2015 04:43
>> *To:* PLUG
>> *Subject:* libreofficecalc formula
>>
>>
>>
>> (budget)
>>
>> (real)
>>
>> (bdgt remain)
>>
>> 600
>>
>> 600
>>
>> 0
>>
>> 700
>>
>>                    50
>>
>> 650
>>
>>
>>
>> The above is how I have it now. I want to be able to enter an amount into
>> 'real' and for the formula to subtract it from budget and to put the
>> remainder in 'bdgt remain'. Please, how do I do it?
>>
>>
>>
>> --
>>
>> :-)~MIKE~(-:
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>>
>
>
>
> --
> :-)~MIKE~(-:
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20150903/e2fe79cb/attachment.html>