OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

SOLVED: make every entry negative

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
PegM_4
General User
General User


Joined: 28 Oct 2007
Posts: 39

PostPosted: Thu Sep 29, 2011 4:01 am    Post subject: SOLVED: make every entry negative Reply with quote

Can I create a column that will make every entry in it a negative without a - in front of the number?

I'm trying to create my own check registry and would like to have every entry in the "Credit" column be negative without my typing in the - in front of the number. Is this even possible?

Thanks
Peg


Last edited by PegM_4 on Sat Oct 01, 2011 7:07 am; edited 1 time in total
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Thu Sep 29, 2011 4:53 am    Post subject: Reply with quote

Hi,

If you have a Debit and Credit Column all numbers should be positive.
When you do calculations you make sure that you subtract Credits.
So your Closing Balance should be Opening Balance+SUM(Debit)-SUM(Credits)

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
PegM_4
General User
General User


Joined: 28 Oct 2007
Posts: 39

PostPosted: Thu Sep 29, 2011 5:34 am    Post subject: Reply with quote

mgroenescheij wrote:
Hi,

If you have a Debit and Credit Column all numbers should be positive.
When you do calculations you make sure that you subtract Credits.
So your Closing Balance should be Opening Balance+SUM(Debit)-SUM(Credits)

Martin


Ahh...That makes sense. Thank you.

Peg
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group