| View previous topic :: View next topic |
| Author |
Message |
chembai
Newbie
Joined: 09 Apr 2010
Posts: 2
|
 Posted: Fri Apr 09, 2010 7:19 am Post subject: Simple profit and loss account |
 |
|
(Solved) Can any one please tell me how I can create a simple profit and loss Account .
I have entered Dates in A , Profit in B and Loss in C .I want the total in D .
Can any one help please .
My question has been solved by Mr Ken Johnson who has given me the correct Answer . Thanks to Mr Ken Johnson and the rest of you who gave a hellping hand .
God bless you! .
Last edited by chembai on Sat Apr 10, 2010 7:41 pm; edited 2 times in total |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Apr 09, 2010 12:47 pm Post subject: Re: Simple profit and loss account |
|
|
| chembai wrote: | Can any one please tell me how I can create a simple profit and loss Account .
I have entered Dates in A , Profit in B and Loss in C .I want the total in D .
Can any one help please . |
You need to learn some basic spreadsheet operations. Try any library or used book store for a copy of "Spreadsheets for Dummies" or something similar. It does not have to be about OOo since the basics are the same for any spreadsheet.
Actually though, Villeroy's suggestion is a better one as the software is likely to be much more reliable and secure than trying to do much of this in a spreadsheet.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
stevesaunders
OOo Advocate
Joined: 26 Dec 2009
Posts: 408
|
| Posted: Fri Apr 09, 2010 3:10 pm Post subject: Add |
|
|
in column D
=A1+C1
or
=A1-C1
What are you trying to Total?
_________________
Steve ~ Tennessee USA
Mac OS X 10.6.2 Open Office 3.1 |
|
| Back to top |
|
|
chembai
Newbie
Joined: 09 Apr 2010
Posts: 2
|
| Posted: Sat Apr 10, 2010 5:37 am Post subject: |
|
|
Thanks every one for the help . I dont want a software ,Well, in answer to stevesaunders question I am a small time stock trader and I Day Trade .
At present I am entering the Dates in A , Profit in B and Loss in C and manually
adding the total in D . For example if todays Trade is a profitable one then I enter
profit in coloumn B , leave the coloumn C Blank and enter the amount in coloumn B
again in Coloumn D .
Vice versa if I make a loss tomorrow then coloumn B is blank ,coloumn C is entered
with the loss and in coloumn D I enter the figure in coloumn C (along with the addition
/substraction of the previous day .
So what I want is very simple . Just 3 coloumns . One for profit , the other for loss
and the third one for the cumulative profit/Loss for the month .
The formula must be something like this =B> or < C = D ! Ha ha ha !
Hope the point is understood /Hope no one suggests buying a Stock Trading software !
Its a simple requirement but it may be difficult to create !
Thanks to all for the help rendered . |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1850
Location: Sydney, Australia
|
| Posted: Sat Apr 10, 2010 7:59 am Post subject: |
|
|
With Profits starting in B2, Losses in C2 then cumulative total is given by...
| Code: | | =SUM(B$2:B2)-SUM(C$2:C2) |
in C2 then filled down to the last row of you data.
http://www.4shared.com/file/hx9xgP8n/Cumulative_Total_from_Profit_L.html
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
|
