Hello:

In an Excel 2003 spreadsheet, I have string fields in column C and in column
F. In column G, I have numeric fields.

Column C is the concatenation of columns A and B. Column F is the
concatenation of columns D and E.

I need a formula that will make values in column G negative where the values
in column C match the values in column F.

Let me see if can give an example.

In column C and row 2, you have the string value 10600357778035. This value
is ALSO in column F in row 181 and the corresponding numeric value in column
G in row 181 is "32". So, G181 needs to show -32.

Now, the values in column C in some cases may be in column F multiple times.
But, the point is that if column C is in column F, I want each corresponding
value in column G to be negative instead of positive. How do I do this? Is
there a formula that can do this without the use of VBA?

childofthe1980s