I have a spread sheet where I have two cells that total data from other cells.
I need a formula to put in the cell following the calculation that will print the amount if it is a credit but not print it if it is a debt.
Conversely I need the opposite in another cell.
Can someone please help me. I am learning with excel and formulas.
Thanks
Title changed by Moderator FlameRetired.
Bookmarks