View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Reverse addition!

"ianonline" wrote
in message ...

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.


If you want to define it that way round, subtract the $130 from $100?
--
David Biddulph