gains/losses formulas
 

I am trying to do a spreadsheet which will show gains from a total in
one column and losses from the same total in another column. Please
help.
:confused:


--
kgeorge
------------------------------------------------------------------------
kgeorge's Profile: http://www.excelforum.com/member.php...o&userid=32804
View this thread: http://www.excelforum.com/showthread...hreadid=526221

gains/losses formulas
 

please give more info, I'm not sure exactly what you're trying to do.


--
rbanks
------------------------------------------------------------------------
rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944
View this thread: http://www.excelforum.com/showthread...hreadid=526221

gains/losses formulas
 

I will have a total in column C.
Column D and F will be labeled "gains" and "losses" respectively.
How do I make the "difference" from C1-C2 go into either the gain
column or the loss column?


--
kgeorge
------------------------------------------------------------------------
kgeorge's Profile: http://www.excelforum.com/member.php...o&userid=32804
View this thread: http://www.excelforum.com/showthread...hreadid=526221

gains/losses formulas
 

Cell D2 =if(C1-C2<0,0,C1-C2)
Cell F2 =if(C1-C20,0,C1-C2)


--
rbanks
------------------------------------------------------------------------
rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944
View this thread: http://www.excelforum.com/showthread...hreadid=526221