I have 8 columns. My values are in Column 7. These are all 'Positive' values, but the detail in Column D indicates if these values are actually negative or positive (that seems odd, but thats my data layout)

I want to replace values with a minus, if the text "Invoice" or "Debit Note" is in Column D on the same row

E.g. Currently Column G shows 8,536.50, but Column D for this Row has "Invoice" detailed, thus I wish to change the value in Column G to -8,536.50

My data I extract from a system, so the length of it may vary depending on when I extract it