I have an Excel (2013) file that lists transactions for our AP team. This report is run on a regular basis by accounts payable.
Column D indicates whether the transaction is "Invoice" or "Credit Memo".
Column I is the transaction dollar amount.
Is there a way that I can convert the transaction dollar amount (Column I) from a positive to a negative number if Column D states "Credit Memo"? It would really only need to be a one time run when the file is opened as the report is generated on a regular basis.