Positive or Negative Value in a Cell if a Nearby Cell is One of Two Values

[MntnrMark]

I have a column, say its Column C, that has multiple rows showing either a "P" (for Positive) or "N" (for Negative) impact on endeavors described in the various Rows of Column B.

I then type a numerical value between 1 and 5 in Column D to reflect the severity/lack thereof of the impact.

I want the value in Column D to be a positive value if "P" shows up to the left in Column C, or a negative value (meaning it displays as -1, -2, -3, etc.) if "N" shows up to the left in Column C.

What's the easiest way to do that? I did it but in a very cumbersome way and would like to simplify the method.

Thanks.

 

[MntnrMark]

PERFECT! THANK YOU! (In the future I'll give the EXACT row and column designations I'm using.)

 

[Joe4]

You are welcome.
Sorry for the delay in responding, but I was out most of the day.