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

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

Reverse addition!
 

how about
-(a1-b1)

--
Don Guillett
SalesAid Software

"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.

Ian


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

Reverse addition!
 

Simply reverse the calculation?

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


"ianonline" wrote:


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

Reverse addition!
 

... should be B-A!!!

"Toppers" wrote:

Simply reverse the calculation?

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


"ianonline" wrote:


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

Reverse addition!
 

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!
================================================== ===

"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.

Ian


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