mpsgrp
asked on
Excel 2013 Convert Positive to Negative if another cell contains specific text
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.
AP-Transaction-Report.xlsx
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.
AP-Transaction-Report.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked absolutely perfectly. Thank you so much!
=IF(D2 = "Credit Memo", AC2* -1, AC2)
See the attached file for an example
AP-Transaction-Report.xlsx