libreofficecalc formula

[Michael Havens]

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.

On Thu, Sep 3, 2015 at 9:21 AM, Rusty Ramser <rusty_ramser at hotmail.com>
wrote:

> 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.
>
>
>
>
>
> *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 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~(-:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20150903/02b1a7a8/attachment.html>