Add Numbers from One or Another Cell

[Kilch]

Hi all, first post here as I am stuck on formula.



I am creating a spreadsheet for keeping track of gains/losses of stocks. I am trying to automatically add a number from one of either two cells into the "Total To Report" column. The cells are either from the "Total Gain/Loss $" or the "Fed Taxes Owed" and "State Tax Owed" added together.

What I am looking for is if I get a gain after selling stocks, I want the taxes I owe ("Fed Taxes Owed" and "State Tax Owed" added together) amount into the "Total To Report" If on the other hand, if I lose on an invest, I want the total from the "Total Gain/Loss $" column to go into the "Total To Report".

Any help would be great appreciated.

Thanks,
Kilch

[gebobs]

=if(f4>0,j4+l4,if(f4<0,g4,0))

[Kilch]

Thanks gebobs Worked great. Just one correction. Had to change F4 to G4.

Again Bob, thanks a bunch.

Kilch

Originally Posted by gebobs

=if(f4>0,j4+l4,if(f4<0,g4,0))

[gebobs]

Glad you could straighten it out! :-)