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 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@lists.phxlinux.org [mailto: > plug-discuss-bounces@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@lists.phxlinux.org > To subscribe, unsubscribe, or to change your mail settings: > http://lists.phxlinux.org/mailman/listinfo/plug-discuss > -- :-)~MIKE~(-: