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" 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 > 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@lists.phxlinux.org [mailto: >> plug-discuss-bounces@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@lists.phxlinux.org [mailto: >> plug-discuss-bounces@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@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~(-: > > --------------------------------------------------- > 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 >