LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ianonline
 
Posts: n/a
Default Reverse addition!


I guess you could say this is subtraction, but it's not! I want to enter
the balance of my account at the end of each day in one column and in
the next column to show much money I've made or lost.

I've got the figure right by simply taking the previous balance from
the new balance, for exmaple $130 - $100 gives $30, but I need it to
show -$30 dollars to show it is a loss, not a $30 gain.

Any help you can give is much appreciated. Thank you.

Ian


--
ianonline
------------------------------------------------------------------------
ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279
View this thread: http://www.excelforum.com/showthread...hreadid=555250

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reverse column order with a macro [email protected] Excel Discussion (Misc queries) 3 June 1st 06 10:39 PM
Reverse a Macro - works like back button spydor Excel Discussion (Misc queries) 1 January 3rd 06 12:39 AM
reverse data megsie jack Excel Discussion (Misc queries) 1 September 30th 05 06:00 AM
Printing same table on reverse side of all pages. dziw Excel Discussion (Misc queries) 1 July 6th 05 06:26 PM
Reverse the sign of a number in a cell Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:23 PM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"