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

Attached Images

StockGainLossSS.jpg (173.1 KB, 17 views)