How to make one cell equal to the negative of another

[BrianJ]

I need to make one cell equal to the negative value of a cell in a different row in the same column.  Can anyone assist?

[Luke_C]

@BrianJ Can you share some sample data? Input & expected output

[BrianJ]

Pong Offset 1 =0, but needs to be the negative of Sum_F40.  Hope that makes sense.

[BrianJ]

Pong_Offset 1 is zero Projected Cost amount, but needs to be the negative of whatever is in Sum_F40 Projected cost amount.

[Luke_C]

How can we logically associate Pong_Offset1 to Sum_F40? What goes with Offset 2 and so on? 

[BrianJ]

There's no direct association, except one (Pong_Offset 1) should be added in as the negative of the other.  In Excel I'd do a lookup for '95005' and pickup the corresponding value.  

[gabrielvilella · Accepted solution]

Hi @BrianJ, here is one way of doind this, I am using an association table as reference.

[BrianJ]

Awesome.  Thanks @gabrielvilella Let me give that a try.

[BrianJ]

@gabrielvilella

Many thanks.  It worked like a dream.  Really appreciate your help.

[gabrielvilella]

Happy to help @BrianJ! 🙂