Add Numbers from One or Another Cell
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
|