Reverse addition!

I

ianonline

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
 
D

David Biddulph

ianonline said:
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.
Click to expand...

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

Toppers

Simply reverse the calculation?

A B B-C
Previous Current Gain/Loss
130 100 -30
100 130 30
 
R

RagDyeR

With old balance in A2, and new balance in B2, try this in C2:

=(B2<>"")*-(A2-B2)

And copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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.

Ian
 
Top