You can actually have VBA code run that will check column D's values and
change the sign in the corresponding value in column E. However, THAT IS A
BAD IDEA. It's usually important to preserve the original value, so you know
whether you've flipped the sign.
Assuming that you *should* keep the value in E2, then in F2 enter the formula:
