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: [email protected] [mailto:[email protected]] 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 - [email protected] To subscribe, unsubscribe, or to change your mail settings: http://lists.phxlinux.org/mailman/listinfo/plug-discuss
