You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by paulranger <ra...@southernphone.com.au> on 2018/02/16 03:54:09 UTC
Syntax in Calc to denote current date and financial balance.
Hello fellow AOO users and fans,
I need to create a simple financial statement spreadsheet to indicate readily the available funds to a charitable body at any given date.
The formulae syntax I am seeking will enable me to
• formulate a cell to the current date;
• calculate new balance after new credit/debit entry is inserted into spreadsheet - e.g. BALANCE (F6) added to new entry (E7) to give new balance in cell F7.
I am grateful for any advice AOO users may be able to offer.
Sincerely, ranger1.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Syntax in Calc to denote current date and financial balance.
Posted by John van Barneveld <jv...@bigpond.com>.
The function for the current date is =TODAY()
If you have a list of entries in column E and the running balance in F
(I assume this from your question) then the running balance is
calculated by adding the new entry to the value in F6. The formula is
then =E7+F6. Copy this formula down row F and it will use relative cell
addressing (ie the next line down in F will read =E8+F7).
John van Barneveld
------ Original Message ------
From: "paulranger" <ra...@southernphone.com.au>
To: users@openoffice.apache.org
Cc: ranger1@southernphone.com.au
Sent: 16/02/2018 1:54:09 PM
Subject: Syntax in Calc to denote current date and financial balance.
>Hello fellow AOO users and fans,
>
>I need to create a simple financial statement spreadsheet to indicate
>readily the available funds to a charitable body at any given date.
>
>The formulae syntax I am seeking will enable me to
>
>• formulate a cell to the current date;
>• calculate new balance after new credit/debit entry is inserted into
>spreadsheet - e.g. BALANCE (F6) added to new entry (E7) to give new
>balance in cell F7.
>
>I am grateful for any advice AOO users may be able to offer.
>
>Sincerely, ranger1.
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>For additional commands, e-mail: users-help@openoffice.apache.org
>
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org