libreofficecalc formula

[Michael Havens]

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