libreofficecalc formula

[Rusty Ramser]

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] 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~(-:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-discuss/attachments/20150903/d41925b6/attachment.html>