Hi all,
I'm looking for a macro that will help me accomplish the following:
In column B, I have numerical values that range from -10 to 10.
In column C, I have one of two values: 1, or 2.
What I'd like is:
If the value in column C is 1, then multiply the value in Column B by -1.
If the value in column C is 2, then multiply the value in Column B by 1 (do nothing).
And these values should populate column C, and clear column B.
So what this would look like on a sample:
Before:
B1: 6 C1: 1
B2: -4 C2: 2
B3: 1 C3: 2
B4: 5 C4: 1
After:
B1: empty C1: -6
B2: empty C2: -4
B3: empty C3: 1
B4: empty C4: -5
Thanks for any help!
Bookmarks